System or internal errorDSRA0010E: SQL State = IX000, Error Code = -79716
Posted in 2007
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