Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

stale connection exception in JDBC

Pradeep Gupta - Oracle-OracleJan 13 2017 — edited Jan 16 2017

Hi, In WebSphere Application Server, We are getting StaleConnectionException issue and customer application get hung for some time.

We have set expiry time and idle time in our database as (SQLNET.EXPIRE_TIME = 10 and IDLE_TIME = 15).

What is the reason of connections getting stale? and how can we avoid (or minimize) this?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2017

Added on Jan 13 2017

#java-database-connectivity-jdbc

7 comments

2,212 views