This week's book giveaway is in the Cloud/Virtualization forum.
We're giving away four copies of Learning OpenStack Networking: Build a solid foundation in virtual networking technologies for OpenStack-based clouds and have James Denton on-line!
See this thread for details.
Win a copy of Learning OpenStack Networking: Build a solid foundation in virtual networking technologies for OpenStack-based clouds this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

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

 
Greenhorn
Posts: 1
  • 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.
 
Greenhorn
Posts: 20
  • 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.
 
Greenhorn
Posts: 2
  • 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.
 
Greenhorn
Posts: 1
  • 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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!