I am using jboss, all the program works fine with jdbc-odbc bridge, and works for some ejb using ms jdbc driver, but for few other ejb, it this the error "ResultSet can not re-read row data for column 1": Does any body know why?
Thanks. David 09:52:19,997,JAWSPersistenceManager] findBySeries command executing: SELECT PRD_PRODUCT.id FROM PRD_PRODUCT where SUBSTRING(ID,1,2) = ? ORDER BY ID desc [09:52:19,997,JAWSPersistenceManager] Set parameter: idx=1, jdbcType=VARCHAR, value=12 [09:52:20,037,Default] Product found:5 [09:52:20,037,JAWSPersistenceManager] Load command executing: SELECT PRD_SERIES.id,PRD_SERIES.subject_area,PRD_SERIES.subtitle,PRD_SERIES.sub ject,PRD_SERIES.ratings,PRD_SERIES.abb_toc,PRD_SERIES.title FROM PRD_SERIES WHERE id=? [09:52:20,037,JAWSPersistenceManager] Set parameter: idx=1, jdbcType=VARCHAR, value=12 [09:52:20,067,JAWSPersistenceManager] Unable to read from ResultSet: java.lang.reflect.InvocationTargetException [09:52:20,067,JAWSPersistenceManager] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for column 1. [09:52:20,077,Series] TRANSACTION ROLLBACK EXCEPTION: javax.transaction.TransactionRolledbackException: Load failed; nested exception is: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for column 1.; nested exception is: java.rmi.ServerException: Load failed; nested exception is: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for column 1. java.rmi.ServerException: Load failed; nested exception is: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for column 1. java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]ResultSet can not re-read row data for column 1. 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.pool.jdbc.ResultSetInPool.getObject(Unknown Source) at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand. java:401) at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand. java:500) at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.loadOneEntity(JDBC LoadEntityCommand.java:219) at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.handleResult(JDBCL oadEntityCommand.java:176) at org.jboss.ejb.plugins.jaws.jdbc.JDBCQueryCommand.executeStatementAndHand leResult(JDBCQueryCommand.java:59) at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java :156) at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEn tityCommand.java:147) at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersist enceManager.java:156) at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceMan ager.java:362) at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySync hronizationInterceptor.java:287) at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInt erceptor.java:197) at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor .java:125) at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java: 138) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor CMT.java:347) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:100) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav a:127) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:170) at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:428) at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContai nerInvoker.java:410) at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContai nerInvoker.java:491) at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(Gener icProxy.java:335) at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.jav a:133) at $Proxy66.getTitle(Unknown Source) at catalog.jsp._0002fcatalog_0002fjsp_0002fseriesdetail_0002ejspseriesdetai l_jsp_0._jspService(_0002fcatalog_0002fjsp_0002fseriesdetail_0002ejspser iesdetail_jsp_0.java:189) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServle t.java:130) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServle t.java:282) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.jav a:812) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(H ttpConnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416 ) at org.apache.tomcat.util.ThreadPool$ControlRunnable -----Original Message----- From: David Cao Sent: Monday, December 17, 2001 7:07 PM To: JBoss 2 Subject: [JBoss-user] Does anybody Configure jboss for MS JDBC Driver ?? Does anybody successful use MS JDBC driver with jboss ? I set up with it, but it always see it can't create prepared statement, does anybody can forward my a sample configuration? Thanks, David _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
