Jboss JMS error - help needed

[ravichittari]

I am getting the following error in my server logs.

Does this mean (a) My defaultDS connection that points to hsqldb is max-ed out on connection pool? Hsqldb is used for jms messages.

OR it is jms-ds.xml that manages jmsXA ds?


ERROR [org.jboss.resource.adapter.jms.JmsSessionFactoryImpl] could not create session
javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:301)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
at org.


Thanks for your help..

[anilit99]

can you post some configurations - i mean what is the hsql-db.xml looking like ?

[ravichittari]

The standard stuff that comes with jboss isntall. Below are two relevant params for hsqldb-ds.xml

<!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
<min-pool-size>5</min-pool-size>

<!-- The maximum connections in a pool/sub-pool -->
<max-pool-size>20</max-pool-size>


For jms-ds.xml, again standard stuff
<tx-connection-factory>
<jndi-name>JmsXA</jndi-name>
<xa-transaction/>
<rar-name>jms-ra.rar</rar-name>
<connection-definition>org.jboss.resource.adapter.jms.JmsConnectionFactory</connection-definition>
<config-property name="SessionDefaultType" type="java.lang.String">javax.jms.Topic</config-property>
<config-property name="JmsProviderAdapterJNDI" type="java.lang.String">java:/DefaultJMSProvider</config-property>
<max-pool-size>20</max-pool-size>
<security-domain-and-application>JmsXARealm</security-domain-and-application>
</tx-connection-factory>


My suspicion is that the max pool size in tx-connection-factory defined in jms-ds.xml is low for the txns I am handling. Hence getting this error.
But, want to see if anyone else has run into this issue.

Would be nice if Jboss wiki has some good pointers to this topic.

[skajotde]

<max-pool-size>20</max-pool-size>

It is defaults values, You should to suit its to own needs / average load.

And try check in JMX listConnectionInUse() in CachedConnectionManager or something similiar. Mayby you are not release some connections.