JDBC链接SQLServer 2000取text类型字段的问题,解决者100分奉送
我有JDBC链接SQLServer 2000数据库中的一个表,有一个字段是类型是text的,
我用rs.getString(3) //3为字段是类型是text的字段编号一取就出错,但取其它类型的没事,放到EJB中通过findByPrimaryKey取出来也没有事。
org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Re
sultSet can not re-read row data for column 3.
以下是我链接数据库的JAVABEAN
private void getContext() {
try {
ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:/MSSQLDS");
try {
con = ds.getConnection();
}
catch (SQLException ex1) {
System.out.println("new getConnection error Message is " +
ex1.getMessage());
}
try {
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
}
catch (SQLException ex2) {
System.out.println("new createStatement error Message is " +
ex2.getMessage());
}
}
catch (NamingException ex) {
System.out.println("new InitialContext error Message is " + ex.getMessage());
}
}
public void Record(String _strSql) {
System.out.println(_strSql);
try {
rs = stmt.executeQuery(_strSql) ;
rs.last() ;
this._intRowCount = rs.getRow() ;
rs.first() ;
}
catch (SQLException ex) {
System.out.println("new getRecord error Message is " + ex.getMessage());
}
}