Since two days our application cannot acquire jndi/JDBC connections anymore.
The same set up: WebSphere 6.1., our application was working until two days.
I do NOT know if someone changed some configuration since then.
When our application start up and requests a jndi/JDBC connection we get J2CA0045E, Connection not available
What we already tried:
followed all instructions: http://www-01.ibm.com/support/docview.wss?uid=swg21385033
Investigated the pool. Druing application startup with:
$AdminControl invoke $ds showPoolContents (we configured $ds correctly before)
we get ...Instance not found
After the application has started (which takes a long time due to the fact that no connections are available)
The pool seems fine and with the above command we can see:
MCWrapper ... Managed connection .... State: STATE_ACTIVE_FREE, whereas during our application startup I can see in the SystemOut.log of the WAS: MCWrapper ... Managed connection .... State: STATE_TRAN_WRAPPER_INUSE
2. Created a new JDBC connection from scratch
The JDBC connections itself is working fine, we get a connection when testing in the wasadmin web console by pressing the button "Test Connection"
->A single connection is fine
It seems that the Connection pool has a problem.
We have no further ideas how to analyse this problem more in depth or how to fix it
Any help is VERY appreciated