This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes Getting org.jboss.util. NestedSQLException : No ManagedConnections available Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Getting org.jboss.util. NestedSQLException : No ManagedConnections available" Watch "Getting org.jboss.util. NestedSQLException : No ManagedConnections available" New topic
Author

Getting org.jboss.util. NestedSQLException : No ManagedConnections available

prakash gandi
Greenhorn

Joined: May 31, 2005
Posts: 1
Hi all ,

I am using Jboss 3.2.5, is there any solution to avoid getting this exception
org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 5000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within c
onfigured blocking timeout ( 5000 [ms] ))

I have increased the blocking timeout also ,& We are closing all the connections properly and there is no heavy load on the server also but still this exception is coming.

Can any one please let me know the solution for this ASAP.

Thanks in advance,
Prakash.
Saulius Sinkunas
Greenhorn

Joined: May 18, 2005
Posts: 20
Are you sure your EJBs are using DB connections longer than 5000ms? What is DB pool size? How many concurent users do you have? I think you can set timeout to 60000 (1 minute) as EJB server can be loaded hard. Or you have to set bigger DB pool size. It is better than to get this exception about used all DB connections.
prakashchulbuly sequeria
Greenhorn

Joined: May 31, 2005
Posts: 2
Yes i have kept 80000 ms as blocking time out but still the exception is coming . What is the solution for this ?

Reponse to this is greatly appreciated .

Thx,
Prakash.
Padmanabhan Sriram
Greenhorn

Joined: Apr 13, 2005
Posts: 1
Please check whether you are closing all the connections. For this take a log of the ConnectionManager of JBoss which indicates how many connections are closed or alive or locked in the pool. One more thing i guess i have read there is some leakage of connection in 3.2.5 connection pooling in JBoss. Any way try getting the log of the managed connection pool of JBoss. Here is the piece of code you would want to add in log4j.xml. So that you get the log for the connection manager

<appender name="DbLogFile" class="org.jboss.logging.appender.RollingFileAppender">
<param name="File" value="${jboss.server.home.dir}/log/Connection.log"/>
<param name="Append" value="false"/>
<param name="MaxFileSize" value="500KB"/>
<param name="MaxBackupIndex" value="1"/>

<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d %-5p [%c{1}] %m%n"/>
</layout>
</appender>
<category name="org.jboss.resource.connectionmanager">
<priority value="TRACE" class="org.jboss.logging.XLevel"/>
<appender-ref ref="MYFILE"/>
</category>

Regards
Sriram.P
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Getting org.jboss.util. NestedSQLException : No ManagedConnections available