This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

No ManagedConnections available within configured blocking timeout

 
nitin dandriyal
Greenhorn
Posts: 2
  • 0
  • 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: 2851
10
Fedora Firefox Browser Java
  • 0
  • 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
  • 0
  • 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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic