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 protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
