pedro
2007-08-02 15:18:10 UTC
Hi,
We have a web application deployed on a websphere 6 application server
that's used to make some queries over an informix database. When
executing a specific operation the apps executes a query on the
database and gets the following exception:
com.ibm.websphere.ce.cm.StaleConnectionException: System or internal
errorDSRA0010E: SQL State = IX000, Error Code = -79,716
at
sun.reflect.GeneratedConstructorAccessor63.newInstance(Unknown Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:
45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:
521)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:
523)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:
578)
at
com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.mapException(InternalGenericDataStoreHelper.java:
533)
at
com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:
1121)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.synchronizePropertiesWithCRI(WSRdbManagedConnectionImpl.java:
2411)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.getConnection(WSRdbManagedConnectionImpl.java:
2680)
at com.ibm.ejs.j2c.MCWrapper.getConnection(MCWrapper.java:
1959)
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:
599)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:
431)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:
400)
at
pt.tmn.provisioning.web.utils.DatabaseUtils.getConnection(DatabaseUtils.java:
102)
at
pt.tmn.provisioning.web.utils.DatabaseUtils.executeQuery(DatabaseUtils.java:
51)
at
pt.tmn.provisioning.web.mvpn.dao.MvpnCrmDao.listAccounts(MvpnCrmDao.java:
117)
at
pt.tmn.provisioning.web.mvpn.actions.MvpnCrmAction.listAccounts(MvpnCrmAction.java:
109)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
64)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:615)
at
org.apache.struts.actions.ActionDispatcher.dispatchMethod(ActionDispatcher.java:
335)
at
org.apache.struts.actions.ActionDispatcher.dispatchMethod(ActionDispatcher.java:
318)
at
org.apache.struts.actions.ActionDispatcher.execute(ActionDispatcher.java:
220)
at
pt.tmn.provisioning.web.mvpn.actions.MvpnCrmAction.execute(MvpnCrmAction.java:
67)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:
431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:
1196)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
763)
After some research I thought that it had something to do with this
problem http://www-1.ibm.com/support/docview.wss?uid=swg21240540 and
so we updated the JDBC driver on the application server to the version
3.00.JC3. However the problem persists.
Does anybody know how can I fix this? Is this an Informix/Websphere
problem, or is my application doing anything wrong?
Thanks in advance,
Pedro
We have a web application deployed on a websphere 6 application server
that's used to make some queries over an informix database. When
executing a specific operation the apps executes a query on the
database and gets the following exception:
com.ibm.websphere.ce.cm.StaleConnectionException: System or internal
errorDSRA0010E: SQL State = IX000, Error Code = -79,716
at
sun.reflect.GeneratedConstructorAccessor63.newInstance(Unknown Source)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:
45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:
521)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:
523)
at
com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:
578)
at
com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.mapException(InternalGenericDataStoreHelper.java:
533)
at
com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:
1121)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.synchronizePropertiesWithCRI(WSRdbManagedConnectionImpl.java:
2411)
at
com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.getConnection(WSRdbManagedConnectionImpl.java:
2680)
at com.ibm.ejs.j2c.MCWrapper.getConnection(MCWrapper.java:
1959)
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:
599)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:
431)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:
400)
at
pt.tmn.provisioning.web.utils.DatabaseUtils.getConnection(DatabaseUtils.java:
102)
at
pt.tmn.provisioning.web.utils.DatabaseUtils.executeQuery(DatabaseUtils.java:
51)
at
pt.tmn.provisioning.web.mvpn.dao.MvpnCrmDao.listAccounts(MvpnCrmDao.java:
117)
at
pt.tmn.provisioning.web.mvpn.actions.MvpnCrmAction.listAccounts(MvpnCrmAction.java:
109)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
64)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:615)
at
org.apache.struts.actions.ActionDispatcher.dispatchMethod(ActionDispatcher.java:
335)
at
org.apache.struts.actions.ActionDispatcher.dispatchMethod(ActionDispatcher.java:
318)
at
org.apache.struts.actions.ActionDispatcher.execute(ActionDispatcher.java:
220)
at
pt.tmn.provisioning.web.mvpn.actions.MvpnCrmAction.execute(MvpnCrmAction.java:
67)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:
431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
236)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:
1196)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
763)
After some research I thought that it had something to do with this
problem http://www-1.ibm.com/support/docview.wss?uid=swg21240540 and
so we updated the JDBC driver on the application server to the version
3.00.JC3. However the problem persists.
Does anybody know how can I fix this? Is this an Informix/Websphere
problem, or is my application doing anything wrong?
Thanks in advance,
Pedro