File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

getting sqlstaleexception

 
Avneet Singh
Ranch Hand
Posts: 51
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 36
Eclipse IDE Java ME Oracle
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should check with the IBM driver forum for help!
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic