Home

Download jtds-1.2.8.jar

http://sourceforge.net/projects/jtds/files/jtds/

At Linux Box:

nano DemoJdbcRowSet.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.sql.rowset.JdbcRowSet;
public class DemoJdbcRowSet {
 /**
  * @param args
  */
 public static void main(String[] args) {
  // TODO Auto-generated method stub
  try {
   //import driver
   Class.forName("net.sourceforge.jtds.jdbc.Driver");
   //connection to database
   Connection conn=DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.0.100:1433;databaseName=test;user=sa;password=password;");
   Statement state=conn.createStatement();
   String sql="SELECT * FROM areacode where id=1";
   ResultSet result=state.executeQuery(sql);
   while (result.next())
   {
    System.out.println(result.getString("id")+"\t"+result.getString("areacode"));
   }
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } 
 }
}

javac -classpath  .:jtds-1.2.8.jar  DemoJdbcRowSet.java
java -classpath  .:jtds-1.2.8.jar  DemoJdbcRowSet

copy jtds-1.2.8.jar and DemoJdbcRowSet.class into Yun.

root@Arduino:/mnt/sda1# jamvm  -classpath  .:jtds-1.2.8.jar  DemoJdbcRowSet
1       354