0 Replies Latest reply on Jun 7, 2003 7:19 PM by Keith Elliott

    ResultSet can not re-read

    Keith Elliott Newbie

      I have an application that has been running for years on MySQL. I now need to run it on MS SQL Server 2000, and I am having a problem.

      I get the following error:

      java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
      at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
      at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
      at com.microsoft.jdbc.base.BaseResultSet.getObject(Unknown Source)
      at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:422)
      at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:524)
      at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.loadOneEntity(JDBCLoadEntityCommand.java:229)
      at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.handleResult(JDBCLoadEntityCommand.java:188)
      ...

      I am using Microsoft's JDBC driver. I tried setting the SelectMethod=cursor, but this does not affect it.

      I am running Jboss 3.0.1.

      Any ideas?

      Thanks a bunch!
      Keith