Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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 agree. Here's the link:
subject: getting sqlstaleexception
It's not a secret anymore!