Eclipse Community Forums: EclipseLink » Recovering from connection exceeded time limit

Home » Eclipse Projects » EclipseLink » Recovering from connection exceeded time limit(Oracle connection time exceeded and logged off. How to create a new connection?)

Show: Today's Messages :: Show Polls :: Message Navigator

Recovering from connection exceeded time limit [message #1772762]

Thu, 14 September 2017 21:43

Phil Scadden

Messages: 11
Registered: July 2010

Junior Member

Running a very job (indexing tens of thousands of document with database look up), I get this error:
java.sql.SQLException: ORA-02399: exceeded maximum connect time, you are being logged off

Error occurs with at a repository.findOne call.

The process is running under tomcat.

What I need to do ( I think) is log back into Oracle and get a new connection. However, JPA pretty effectively hides all that detail. (And Spring even further). How do I proceed?

Report message to a moderator

Re: Recovering from connection exceeded time limit [message #1772905 is a reply to message #1772762]

Mon, 18 September 2017 14:47

Chris Delahunt

Messages: 1339
Registered: July 2009

Senior Member

You would need to post the details of how you have configured the connections. If you are using JPA/EclipseLink to handle the pooling (rather than a datasource), see
https://docs.oracle.com/middleware/1212/toplink/TLJPA/p_connection_pool.htm#TLJPA1070
and
https://stackoverflow.com/questions/5289075/how-to-modify-eclipselink-jpa-2-0-connection-retry-behavior

Report message to a moderator

Re: Recovering from connection exceeded time limit [message #1772931 is a reply to message #1772905]

Mon, 18 September 2017 21:04

Phil Scadden

Messages: 11
Registered: July 2010

Junior Member

I am using a datasource. However, I have since discovered that Oracle manager was killing off connections longer than 4 hours because he was having issues with zomble connections exhausting the pool.He has extended connection time to 4 days.

Report message to a moderator

Previous Topic:	Attempting to execute an operation on a closed EntityManager
Next Topic:	ConcurrentModificationException using ReadObjectquery with EclipseLink 2.6.4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 03:15:55 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter