troubleshooting Question

Websphere JDBC Connection: J2CA0045E, Connection not available

Avatar of mruff
mruff asked on
JavaApplication ServersJava App Servers
4 Comments1 Solution3660 ViewsLast Modified:
Dear experts,
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:
1.
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
Many thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros