• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to get managed connection

 
bhadre gowda
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 10444
227
IntelliJ IDE Ubuntu
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic