This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Portals and Portlets and the fly likes No ManagedConnections available within configured blocking timeout Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Portals and Portlets
Bookmark "No ManagedConnections available within configured blocking timeout" Watch "No ManagedConnections available within configured blocking timeout" New topic
Author

No ManagedConnections available within configured blocking timeout

nitin dandriyal
Greenhorn

Joined: Jul 03, 2008
Posts: 2
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...


Nitin
Amit Ghorpade
Bartender

Joined: Jun 06, 2007
Posts: 2716
    
    6

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


SCJP, SCWCD.
|Asking Good Questions|
rajanikanth bhagavan kanth
Ranch Hand

Joined: May 20, 2008
Posts: 78
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
 
 
subject: No ManagedConnections available within configured blocking timeout
 
Similar Threads
org.jboss. util.NestedSQL Exception
org.jboss. util.NestedSQL Exception
JBoss Connection Pool Size
Spring-Struts Issue
Help in tracking down open database connections