Losing JBoss connection to Oracle

1149245 pts.
Tags:
JBoss
Oracle
We currently have Oracle on JBoss on two separate servers. The connections seem to be dropping and it's been causing issues on JBoss. Is it possible to reconnect to Oracle if the connection is bad while we figure out what's happening with the connection itself?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
There is usually a configuration option on the pool to enable a validation query to be executed on borrow. If the validation query executes successfully, the pool will return that connection. If the query does not execute successfully, the pool will create a new connection.

The JBoss Wiki documents the various attributes of the pool.

<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
Seems like it should do the trick.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: