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?