1 Reply Latest reply on May 22, 2002 11:59 AM by Edwin Mol

    JBoss 2.4.4 & MSSQL 2000

    cgd Newbie

      I'm trying to use the new MSSQL 2000 JDBC Driver from Microsoft with JBoss 2.4.4, but I've an error with jaws on resultset. The resultset can't be re-read !.
      Is there a solution for this problem ? Is it a bug from JAWS or MSSQL ?
      Thx for your help.

      [ACContactBean] java.rmi.ServerException: Load failed; nested exception is:
      [ACContactBean] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for column 1.
      [ACContactBean] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for column 1.
      [ACContactBean] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      [ACContactBean] at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)
      [ACContactBean] at com.microsoft.jdbc.base.BaseResultSet.getObject(Unknown Source)
      [ACContactBean] at org.jboss.pool.jdbc.ResultSetInPool.getObject(ResultSetInPool.java:554)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:405)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:504)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.loadOneEntity(JDBCLoadEntityCommand.java:219)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.handleResult(JDBCLoadEntityCommand.java:176)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHandleResult(JDBCQueryCommand.java:59)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java:160)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:147)
      [ACContactBean] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersistenceManager.java:156)
      [ACContactBean] at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:362)
      [ACContactBean] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:286)
      [ACContactBean] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:208)
      [ACContactBean] at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:136)
      [ACContactBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
      [ACContactBean] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307)
      [ACContactBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
      [ACContactBean] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
      [ACContactBean] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
      [ACContactBean] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:427)
      [ACContactBean] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:489)
      [ACContactBean] at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(GenericProxy.java:335)
      [ACContactBean] at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.java:133)
      [ACContactBean] at $Proxy230.getLogin(Unknown Source)
      [ACContactBean] at arcad.ejb.contact.ACContactStoreBean.findLoginIntranet(ACContactStoreBean.java:479)
      [ACContactBean] at java.lang.reflect.Method.invoke(Native Method)
      [ACContactBean] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:543)
      [ACContactBean] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
      [ACContactBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
      [ACContactBean] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:307)
      [ACContactBean] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
      [ACContactBean] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
      [ACContactBean] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
      [ACContactBean] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:286)
      [ACContactBean] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:395)
      [ACContactBean] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:476)
      [ACContactBean] at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(GenericProxy.java:335)
      [ACContactBean] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:123)
      [ACContactBean] at $Proxy216.findLoginIntranet(Unknown Source)
      [ACContactBean] at arcad.site.servlets.ACConnection.doPost(ACConnection.java:109)
      [ACContactBean] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      [ACContactBean] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [ACContactBean] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
      [ACContactBean] at org.apache.tomcat.core.Handler.service(Handler.java:287)
      [ACContactBean] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
      [ACContactBean] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
      [ACContactBean] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
      [ACContactBean] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
      [ACContactBean] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
      [ACContactBean] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
      [ACContactBean] at java.lang.Thread.run(Thread.java:484)