This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "getting sqlstaleexception " Watch "getting sqlstaleexception " New topic

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

at $Proxy6.commit(Unknown Source)
at com.siperian.mrm.util.threads.MatchThread.closeConnection(
at com.siperian.mrm.match.RangerWorker.closeDB(
at com.siperian.mrm.match.RangerWorker.runRangeStyle(
at com.siperian.mrm.match.RangerWorker.realRun(
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at com.siperian.common.db.ConnectionLogger$ConnectionInvocationHandler.invoke(
... 6 more
Caused by: Closed ConnectionDSRA0010E: SQL State = null, Error Code = 17,008
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
at java.lang.reflect.Constructor.newInstance(
... 10 more

We have updated the oracle drivers to,

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
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: getting sqlstaleexception
It's not a secret anymore!