3 Replies Latest reply on Jun 17, 2013 2:06 AM by Wolf-Dieter Fink

    Unable to get Managed connection

    Santhosh Srinivasan Newbie

      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



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






      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.