No ManagedConnections available within configured blocking timeout

[nitin dandriyal]

Hi All,

I am running a Telecom application with high CAPS(CAlls Per Second), When I run my application for load test(1.3 million calls to DB in 12 hours).
around 5000 calls to DB(Oracle 9i here) failed and below exception was coming..

Catch a SQLException: org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))

What I thought:
1. Increase JBoss *-ds.xml max connections.
2. Increase max number of sessions in init.ora of Oracle DB.
3. For each call a DB procedure is being called(for some stats), So shall I buffer up my DB calls and calls DB Procedure once for say 5 calls?

What can be other possible reasons and solutions?

Thanks in anticipation...

[Amit Ghorpade]

"nitindandriyal " please check your private messages for an important administrative matter. You can see them by clicking the My Private Messages link above.

[rajanikanth bhagavan kanth]

Hi
Check whether the opend connections are closed properly or not.
And also increase the value of connections in configuration files like *-ds.xml files

Regards
Bhagavna R