Unable to get Managed connection

[monsieursanta]

Hi All,

My application has been recently moved from Jboss 4.2 to Jboss 7.1

We are currently creating a lot of inactive sessions in oracle which in the previous server version didnt exist. this leads to error called

Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (30000 [ms])

          at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:377)

          at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

We tried to address the problem by adding the below config in server

          <validation>

                         <check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>

                        <validate-on-match>false</validate-on-match>

                        <background-validation>false</background-validation>

                        <use-fast-fail>false</use-fast-fail>

                                </validation>

After adding this our inactive sessions shot up.. we are finding the "select 1 from dual" as an inactive session.

Any help is appreciated. since we are kind of bamboozled by the same.

Cheers

Santhosh

[monsieursanta]

We have observed from the orale db that there is command 0 in V$sessions.. which practically means its doing nothing.

And also we have set idle timeout config as 1 minute. Ideally shouldnt it release all inactive sessions beyond one minute?

or is there a bug is JBoss 7

[monsieursanta]

Fixed the issue.. but not the way i liked it to do. set the cached connection manager attribute [debug="true"]. to trace and close the leaks if and when happens

[wdfink]

This configuration might have a performance issue.

Also you should use the shown stacktrace to solve the conneciton leak, this will be the root cause!