java调用存储过程
caven 2004-05-12 02:19:38 代码如下:
Class.forName(strDBDriver);
sqlCon = DriverManager.getConnection(strConnstr,user,password);
strSQL = "{call SP_HQConsignOnTheWay(?)}";
sqlStmt = sqlCon.prepareCall(strSQL,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sqlStmt.setString(1,"");
sqlRst = sqlStmt.executeQuery();
System.out.println(sqlRst.getRow());//输出1003,即 TYPE_FORWARD_ONLY
sqlRst.last();
出现错误:java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
我在
/*
sqlStmt = sqlCon.prepareCall(strSQL,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
*/
中设置ResultSet.TYPE_SCROLL_INSENSITIVE了,为什么还是TYPE_FORWARD_ONLY