• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

No ManagedConnections available within configured blocking timeout

 
nitin dandriyal
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 2854
10
Fedora Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
Ranch Hand
Posts: 78
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic