wood burning stoves 2.0*
The moose likes JBoss/WildFly and the fly likes Unable to get managed connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Unable to get managed connection" Watch "Unable to get managed connection" New topic
Author

Unable to get managed connection

bhadre gowda
Greenhorn

Joined: Sep 17, 2011
Posts: 1
Hi,

We are getting the below exception on one of the jboss node.
same we are able to connect to database using other 5 nodes successfully no issue.

Caused by: org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/ytlcXportal; -
nested throwable: (javax.resource.ResourceException: Unable to get managed connection for jdbc/ytlcXportal)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataS
ourceConnectionProvider.java:81)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:162)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1576)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.doQuery(Loader.java:695)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.Loader.loadEntity(Loader.java:1886)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:71)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:65)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3063)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:434)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:415)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:165)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:223)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:126)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:907)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:844)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:837)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:519)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) ... 48 more
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) Caused by: javax.resource.ResourceException: Unable to get managed connection for jdbc/ytlcXportal
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
2011-09-15 23:48:04,212 ERROR [STDERR] (ajp--8209-97) ... 69 more
2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) Caused by: javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
2011-09-15 23:48:04,213 ERROR [STDERR] (ajp--8209-97) ... 73 more

Our Jboss setup is like 6 nodes are in single cluster each machine having 2 nodes.
We are not seeing the error after the server restart.
Can anybody tell me how to fix this issues.


Thanks,
Bhadre Gowda
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10102
    
165

http://community.jboss.org/thread/172457?tstart=0


[My Blog] [JavaRanch Journal]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to get managed connection