Problem using Informix as a ConversationDataSource
Tatiana Goldina
I have set JMS Server to use Informix as a persistent store. (With IBM Informix JDBC Driver, Version 2.21.JC4, non-XA.)
When invoking a conversational method of a web service, I am getting Informix error 255 - "Not in Transaction":
"An unexpected exception occurred while attempting to locate the run-time information for this Web Service. Error: java.sql.SQLException:Not in transaction."
Is it a known behavior? How can I fix it?
JDBC log and stack trace follow:
####<Jan 12, 2004 1:10:12 PM PST> <Info> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001068> <Connection for pool "cgArchivePool" created.>
####<Jan 12, 2004 1:10:12 PM PST> <Info> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001133> <Statement caching not enabled for connection in specified pool "cgArchivePool".>
####<Jan 12, 2004 1:10:12 PM PST> <Info> <Common> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-000628> <Created "1" resources for pool "cgArchivePool", out of which "1" are available and "0" are unavailable.>
####<Jan 12, 2004 1:10:12 PM PST> <Debug> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001036> <[weblogic.jdbc.wrapper.DatabaseMetaData_com_informix_jdbc_IfxDatabaseMetaData@19] getDatabaseProductName()>
####<Jan 12, 2004 1:10:12 PM PST> <Debug> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001036> <[weblogic.jdbc.wrapper.DatabaseMetaData_com_informix_jdbc_IfxDatabaseMetaData@1a] getDriverName()>
####<Jan 12, 2004 1:10:12 PM PST> <Debug> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001036> <[weblogic.jdbc.wrapper.PoolConnection_com_informix_jdbc_IfxSqliConnect@18] [Pool Conn] prepareStatement(SELECT CG_ID FROM JWS_S_RETRIEVE_ARCHIVERETRIEVE), conn = com.informix.jdbc.IfxSqliConnect@1066d88, txIsolationLevel=2, autoCommit=true>
####<Jan 12, 2004 1:10:12 PM PST> <Debug> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001036> <[weblogic.jdbc.wrapper.PreparedStatement_com_informix_jdbc_IfxPreparedStatement@1b] executeQuery()>
####<Jan 12, 2004 1:10:12 PM PST> <Debug> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001036> <[weblogic.jdbc.wrapper.PoolConnection_com_informix_jdbc_IfxSqliConnect@18] [Pool Conn] commit(), conn = com.informix.jdbc.IfxSqliConnect@1066d88, txIsolationLevel=2, autoCommit=true>
####<Jan 12, 2004 1:10:12 PM PST> <Debug> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <BEA-001036> <[weblogic.jdbc.wrapper.PoolConnection_com_informix_jdbc_IfxSqliConnect@18] [Pool Conn] close(), conn = com.informix.jdbc.IfxSqliConnect@1066d88, txIsolationLevel=2, autoCommit=true>
####<Jan 12, 2004 1:10:12 PM PST> <Debug> <JDBC> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <000000> <ConnectionEnv.cleanup, jconn=com.informix.jdbc.IfxSqliConnect@1066d88, isXA=false, isJTS=false, jconn.isolationLevel=2, initialIsolationLevel=2, dirtyIsolationLevel=false>
####<Jan 12, 2004 1:10:12 PM PST> <Error> <WLW> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <000000> <Exception processing edu.caltech.ipac.sirtf.archive.ws.retrieve.ArchiveRetrieve
java.sql.SQLException: Not in transaction.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:349)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3043)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3353)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2254)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2174)
at com.informix.jdbc.IfxSqli.executeCommit(IfxSqli.java:436)
at com.informix.jdbc.IfxSqliConnect.commit(IfxSqliConnect.java:1485)
at weblogic.jdbc.wrapper.PoolConnection_com_informix_jdbc_IfxSqliConnect.commit(Unknown Source)
at com.bea.wlw.runtime.core.bean.BMPContainerBean.initTableAccess(BMPContainerBean.java:1130)
at com.bea.wlw.runtime.core.dispatcher.DispComponentJar.confirmDeployment(DispComponentJar.java:155)
at com.bea.wlw.runtime.core.dispatcher.DispResources.confirmDeployment(DispResources.java:922)
at com.bea.wlw.runtime.core.dispatcher.DispCache.ensureDispUnit(DispCache.java:675)
at com.bea.wlw.runtime.core.dispatcher.HttpServerHelper.getDispUnit(HttpServerHelper.java:468)
at com.bea.wlw.runtime.core.dispatcher.HttpServerHelper.executePostRequest(HttpServerHelper.java:616)
at com.bea.wlw.runtime.core.dispatcher.HttpServer.doPost(HttpServer.java:49)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1053)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:387)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6316)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:317)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3622)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2569)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>
####<Jan 12, 2004 1:10:12 PM PST> <Error> <WLW> <sscdev> <soas_tg> <ExecuteThread: '14' for queue: 'weblogic.kernel.Default'> <<anonymous>> <> <000000> <Returning HTTP 500 due to httpWriteCompileErrors <error> <description>An unexpected exception occurred while attempting to locate the run-time information for this Web Service. Error: java.sql.SQLException:Not in transaction.</description> <source>[unknown source]</source> <line>[unknown line]</line> <column>[unknown column]</column> <prescription>An unexpected error occurred. Please contact sup...@bea.com for further assistance.</prescription> </error> >