aspose file tools*
The moose likes JDBC and the fly likes getting sqlstaleexception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "getting sqlstaleexception " Watch "getting sqlstaleexception " New topic
Author

getting sqlstaleexception

Avneet Singh
Ranch Hand

Joined: Apr 25, 2006
Posts: 51
Hi All,

we have a application where we are getting the following exception. can any one help me out with this exception

java.lang.reflect.UndeclaredThrowableException
at $Proxy6.commit(Unknown Source)
at com.siperian.mrm.util.threads.MatchThread.closeConnection(MatchThread.java:61)
at com.siperian.mrm.match.RangerWorker.closeDB(RangerWorker.java:503)
at com.siperian.mrm.match.RangerWorker.runRangeStyle(RangerWorker.java:729)
at com.siperian.mrm.match.RangerWorker.realRun(RangerWorker.java:747)
at com.siperian.mrm.util.threads.MatchThread.run(MatchThread.java:78)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.siperian.common.db.ConnectionLogger$ConnectionInvocationHandler.invoke(ConnectionLogger.java:185)
... 6 more
Caused by: com.ibm.websphere.ce.cm.StaleConnectionException: Closed ConnectionDSRA0010E: SQL State = null, Error Code = 17,008
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
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.processLocalTransactionCommittedEvent(WSRdbManagedConnectionImpl.java:1831)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.commit(WSJdbcConnection.java:915)
... 10 more


We have updated the oracle drivers to 10.2.0.3,

background,
The application is running on 100 k records and trying to match duplicate records. The server loads the data from the db and then runs the match logic to find potential matches.

Earlier we were getting socket read time out exception but havnt seen that since the oracle driver updates.
T.A. Nguyen
Ranch Hand

Joined: Sep 02, 2008
Posts: 36

You should check with the IBM driver forum for help!


T.A. Nguyen
http://ta.cnci.org
http://www.linkedin.com/in/nguyenta
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: getting sqlstaleexception