File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
prakash gandi
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 20
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic