The error "J2CA0045E: Connection not available while invoking method createOrWaitForConnection for resource jdbc/DEMO." can be caused by many problems.
They are showing a time-out condition where a resource or a managed connection is not available to fulfill a connection request.
Probably you might have many connections or long running transactions to process.
Action Plan:
1. Increase the "Maximum connections" from 10 to 30. This is likely to help fix this issue.
To ask your question:
You can check the current active connection when the ConnectionWaitTimeoutException happened by dumping java threads or javacores.
The following document will guide you to collect requested information. Please use manual collection steps.
[Please follow through the section "Manual collection of troubleshooting data (optional)"]
MustGather: Performance, Hang, or High CPU Issues on Windows
Recommendation:
1. It is recommended to test the scripts which is attached the above document first or before the problem occurred to ensure it does work in your environment.
2. Could you please check the database side? Has database provided enough cursors or connections to serve requests?
Is (Are) there any lock in database table?
3. Please check with your program coding side. Does it close connection(s) to database when it finished the task or transaction?
More Info:
Similar Prob:
No comments:
Post a Comment