Hi,
We are facing a problem with database connections
in JBoss. Our application uses hibernate for O-R mapping and the database
connections are also used through Hibernate calls.
During peak loads, getting the following
exception..
org.jboss.util.NestedSQLException: No ManagedConnections Available!; -
nested throwable: (javax.resource.ResourceException: No ManagedConnections
Available!)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:126) at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:58) at net.sf.hibernate.impl.SessionFactoryImpl.openConnection(SessionFactoryImpl.java:396) at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:2914) at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:56) at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:482) at net.sf.hibernate.loader.Loader.doFind(Loader.java:136) at net.sf.hibernate.loader.Loader.find(Loader.java:620) at net.sf.hibernate.hql.QueryTranslator.find(QueryTranslator.java:928) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1343) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:76) have increased the pool size but still keep getting
the error what could be the cause.
Could be because the connections are not being
closed in all the places in the application? or is there any other reason to
it..
thanks,
Naushad.
|