• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Connection validation, auto reconnect
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

References: 
 >Re: Simple question: inserting data right after table creation (on migration?) (From: Flavio Donadio <email@hidden>)

  • Prev by Date: Re: WOWODC 2013: June 22-23-24
  • Next by Date: Re: Migrations problem with FrontBase
  • Previous by thread: Re: Simple question: inserting data right after table creation (on migration?)
  • Next by thread: Re: Simple question: inserting data right after table creation (on migration?)
  • Index(es):
    • Date
    • Thread