Connection validation, auto reconnect
Connection validation, auto reconnect
- Subject: Connection validation, auto reconnect
- From: JR Ruggentaler <email@hidden>
- Date: Tue, 18 Dec 2012 17:02:34 +0000
- Thread-topic: Connection validation, auto reconnect
I have a Wonder application that is sometimes idle for long periods of
time. The idle Oracle connections are terminated by the network or the DBA
terminates the idle connections on the Oracle server to free up the
connections. When the application is assessed and the connection has been
terminated I get an exception and the request fails. Is there some way to
turn on connection validation and or auto reconnect to recover gracefully
from the exception?
[2012-12-17 22:31:45,519] [WorkerThread1] INFO
er.transaction.adaptor.Exceptions:177 - Database Exception occured: No
more data to read from socketat
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1289)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1237)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:295)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:66)
at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:797)
at
oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:5029
)
at
com.webobjects.jdbcadaptor.JDBCContext.rollbackTransaction(JDBCContext.java
:488)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java
:340)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:
296)
at
com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:22
0)
at
com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEdit
ingContext(EODatabaseChannel.java:897)
at
com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecificati
on(EODatabaseChannel.java:234)
at
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEdi
tingContext(EODatabaseContext.java:3055)
at
com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EOD
atabaseContext.java:3195)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecifica
tion(EOObjectStoreCoordinator.java:488)
at
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOE
ditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1209)
at
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOE
ditingContext.java:4444)
at
com.webobjects.eoaccess.EOUtilities.objectsMatchingValues(EOUtilities.java:
216)
at
com.webobjects.eoaccess.EOUtilities.objectsMatchingKeyAndValue(EOUtilities.
java:190)
at
com.webobjects.eoaccess.EOUtilities.objectMatchingKeyAndValue(EOUtilities.j
ava:320)
I found a thread that discusses a similar issue from MySQL.
http://osdir.com/ml/webobjects-dev/2011-01/msg00333.html
JR
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden