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

       

                <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