Merant and Microsoft - Unable to Create Prepared Statement
diathesis Oct 3, 2001 3:20 PMI've tried JBoss with a variety of SQL Server drivers, including Merant and the new Microsoft driver based on Merant.
Free TDS and the Bridge both tend to give me issues, which I accept. Inet Opta seems to be working well enough, but I get errors with both Merant and the Microsoft driver, as follows:
[User] TRANSACTION ROLLBACK EXCEPTION:Load failed; nested exception is: java.sql.SQLException: Unable to create PreparedStatement!; nested excep tion is: java.rmi.ServerException: Load failed; nested exception is: java.sql.SQLException: Unable to create PreparedStatement! [User] java.rmi.ServerException: Load failed; nested exception is: [User] java.sql.SQLException: Unable to create PreparedStatement! [User] java.sql.SQLException: Unable to create PreparedStatement! [User] at org.jboss.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XA ClientConnection.java:169) [User] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.j ava:158) [User] at org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoa dEntityCommand.java:147) [User] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPers istenceManager.java:156) [User] at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistence Manager.java:362) [User] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntityS ynchronizationInterceptor.java:286) [User] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstance Interceptor.java:208) [User] at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockIntercep tor.java:136) [User] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.ja va:133) [User] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep torCMT.java:307) [User] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:9 9) [User] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor. java:128) [User] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195) [User] at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:427) [User] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPCon tainerInvoker.java:483) [User] at org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(Ge nericProxy.java:335) [User] at org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy. java:133) [User] at $Proxy6.getPassword(Unknown Source) [User] at com.mediumone.thesquare.servlet.Login.authenticateUser(Login.java:101 ) [User] at com.mediumone.thesquare.servlet.Login.doPost(Login.java:57) [User] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) [User] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) [User] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:4 05) [User] at org.apache.tomcat.core.Handler.service(Handler.java:287) [User] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372 ) [User] at org.apache.tomcat.core.ContextManager.internalService(ContextManager. java:812) [User] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758 ) [User] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnectio n(HttpConnectionHandler.java:213) [User] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java: 416) [User] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java :501) [User] at java.lang.Thread.run(Unknown Source)
Anyone have any suggestions on why that would be?
- Geoffrey