File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getting sqlstaleexception
 
Similar Threads
Active Directory Issue
JWS: Executable jar runs but doesn't show the data
Connection error with WAS 5.1 and DB2 z/OS 8.2
Application Deployment Error -
problem connecting to https: server