<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Connection pool problem jboss 5.1 + hibernate oracle 11.2.3.0 DB,Hibernate 3.3.2.GA
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/shirishmaurya">shirish maurya</a> in <i>Performance Tuning</i> - <a href="https://community.jboss.org/message/742129#742129">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">issue with connection management for jboss 5.1 + hibernate, my hibrenate uses jndi name define for connection pooling,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">below is the hibernate configuration</p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,068 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Automatic flush during beforeCompletion(): disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,068 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Automatic session close at end of transaction: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,070 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Scrollable result sets: enabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,070 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> JDBC3 getGeneratedKeys(): disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,071 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Connection release mode: auto</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,072 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Default batch fetch size: 4</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,072 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Generate SQL with comments: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,072 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Order SQL updates by primary key: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,073 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,078 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[ASTQueryTranslatorFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Using ASTQueryTranslatorFactory</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,079 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Query language substitutions: {}</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,079 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> JPA-QL strict compliance: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,079 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Second-level cache: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,079 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Query cache: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,079 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Optimize cache for minimal puts: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,079 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Structured second-level cache entries: disabled</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">03:29:45,092 INFO </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[SettingsFactory]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> Statistics: disabled</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><br/></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">i have also made a connection release mode to<span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> on close and track transation track statement  but no where it helps</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">ds file config</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">min-pool-size>8</min-pool-size></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><max-pool-size>100</max-pool-size></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><blocking-timeout-millis>50000</blocking-timeout-millis></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><use-strict-min>true</use-strict-min></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><track-statements>true</track-statements></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><metadata></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><type-mapping>Oracle11g</type-mapping></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"></metadata></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"></local-tx-datasource></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"></datasources></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">after certain duration of time say 30 mins the connection problem arises, this happens as i increase the concuurent users. the connection are getting closed out from the code.</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">also i see a lot of inactive session at DB end increase duration the test period.<br/></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">org.hibernate.exception.GenericJDBCException: Cannot open connection</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.loader.Loader.doQuery(Loader.java:696)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.loader.Loader.loadCollectionBatch(Loader.java:2057)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.loader.collection.BatchingCollectionInitializer.initialize(BatchingCollectionInitializer.java:70)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventL</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">istener.java:83)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1744)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:366)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:108)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.collection.PersistentBag.iterator(PersistentBag.java:272)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">Caused by: org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/mya/bonusPool; - nested throwable: (javax.re</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">source.ResourceException: Unable to get managed connection for jdbc/mya/bonusPool)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">:82)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">... 84 more</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">Caused by: javax.resource.ResourceException: Unable to get managed connection for jdbc/mya/bonusPool</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManag</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">er2.java:941)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">... 86 more</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 50000 </span><span class="error" style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">[ms]</span><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"> )</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:69</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">0)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">... 90 more</span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;"><br/></span></p><p style="background-color: #eef4f9; font-size: 12px; color: #555555; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"><span style="background-color: #ffffff; color: #000000; font-family: Arial, FreeSans, Helvetica, sans-serif; text-align: -webkit-auto;">is there any particular setting i m missing for hibernate or jboss.</span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/742129#742129">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Performance Tuning at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2078">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>