0 Replies Latest reply on Apr 6, 2018 7:11 AM by Micheal Delson Nadar

    Oracle INACTIVE session keep growing with wildfly-8.2.1.Final

    Micheal Delson Nadar Newbie

      Hi,

       

      We have recently migrated our application server from Jboss 4,2 to wildfly-8.2.1.Final with Oracle11g. As a test, also tried with wildfly-12.0.0.Final, but issue is same as under

       

      Our application is running in wildfly-8.2.1.Final with Oracle 11g now and whenever a query is executed from application to database a session is created in oracle in ACTIVE mode. Then after some time is it converted to INACTIVE mode and this INACTIVE session keeps growing and is never released. If I stop the Wildfly instances, then there is no INACTIVE session available in Oracle server. All gets cleared.  So it is clear that Wildfly is not releasing connections. Is this known issue in wildfly-8.2.1 or is there any specific configuration I have missed. Any pointers will be appreciated.

       

      this same code is working fine in Jboss 4.2

       

      our pooling confi as below

       

      <datasources>

                      <datasource jta="true" jndi-name="java:/test" pool-name="test" enabled="true" use-java-context="true" use-ccm="true">

                          <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=test)(Port=1521))(CONNECT_DATA=(SERVICE_NAME=test)))</connection-url>

                          <driver>oracle</driver>

          <pool>

                                  <min-pool-size>20</min-pool-size>

                                  <initial-pool-size>20</initial-pool-size>

                                  <max-pool-size>200</max-pool-size>

                                  <prefill>true</prefill>

                        <flush-strategy>IdleConnections</flush-strategy>

                         <capacity>

                              <decrementer class-name="org.jboss.jca.core.connectionmanager.pool.capacity.SizeDecrementer">

                                  <config-property name="Size">1</config-property>

                              </decrementer>

                          </capacity>

                              </pool>

                          <security>

                              <user-name>test/user-name>

                              <password>test</password>

                          </security>

                          <validation>

                              <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>

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

                              <validate-on-match>true</validate-on-match>

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

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

                              <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>

                              <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>

                          </validation>

                          <timeout>

                              <set-tx-query-timeout>true</set-tx-query-timeout>

                              <blocking-timeout-millis>5000</blocking-timeout-millis>

                              <idle-timeout-minutes>5</idle-timeout-minutes>

                          </timeout>

                          <statement>

                              <track-statements>false</track-statements>

                              <prepared-statement-cache-size>100</prepared-statement-cache-size>

                              <share-prepared-statements>true</share-prepared-statements>

                          </statement>

                      </datasource>