Connection not available while invoking method createOrWaitForConnection for resource jdbc/ABCD_EFGH.
[4/11/13 15:17:12:467 EDT] 00000073 JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 0, SQLState: null
[4/11/13 15:17:12:468 EDT] 00000073 JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions Connection not available, Timed out waiting for 10001
Indu Priyanka wrote:Hello All,
We have two MDB listeners on our APP server. These are used by two applications to contact our applciation and get data.
These listeners are getting down frequently in recent times. This is causing severe business loss as ours is a mission critical application.
These listeners when get message to our application, we are running couple of DB queries to get data.
Some large transaction is holding the database tables as we see some unusual lock escalation happening on DB tables at the time listeners were down.