SQL server ResultSet is Read only
//stmt = cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
stmt = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
解决办法
TYPE_SCROLL_INSENSITIVE改为 TYPE_SCROLL_SENSITIVE
或者不要使用jtds 驱动
jtds 好像可以解决 2000 数据库转到 2005的差异性！
public static Connection getConn()throws ClassNotFoundException, SQLException{
long start=System.currentTimeMillis();
Connection conn=null;
//com.microsoft.sqlserver.jdbc.SQLServerDriver
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");//2000 jar驱动
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//2005驱动
Class.forName("net.sourceforge.jtds.jdbc.Driver"); jtds驱动 代替sqlserver驱动
String constr;
//constr="jdbc:sqlserver://localhost:3803;databaseName=CDCA_SAS_CCLAND;SelectMethod=cursor"; //2005
//constr="jdbc:microsoft:sqlserver://localhost:3803;DatabaseName=CDCA_SAS_CCLAND;SelectMethod=cursor;";//2000
constr="jdbc:jtds:sqlserver://localhost:3803/CDCA_SAS_CCLAND";
//String url="jdbc:jtds:sqlserver://localhost:1433/pubs";
conn=DriverManager.getConnection(constr,"sa","123456");
long end=System.currentTimeMillis();
System.out.println("kangkang");
return conn;
}
页:
[1]