0 Replies Latest reply on May 3, 2018 9:53 AM by surendra Thummanagoti

    Database connection pool issue on JBoss 6.4

    surendra Thummanagoti Newbie

      We have JBoss-eap.6.4.0 with below Database connection pool setting and oracle DB as a backend.  We have an issue with locking the connection pool and unable to run any other connection and its not releasing any connection from pool, by the way we are restarting the jboss server.

       

      Detail Explanation : Whenever DB jobs are running with a big thread/data/queries, at that time JBoss connect to DB, due to the slow response of DB, all connection pool was full on all servers and locked. Once the DB come back, still JBOSS connection pool was full and will not come back and locked the connection pool. Due to this we are forcing to restart the servers.

       

      Standalone-ha.xml:

                     <datasource jndi-name="java:/jdbc/SID" pool-name="Name" enabled="true" use-java-context="true" statistics-enabled="true">

                          <connection-url>jdbc:Oracle:thin:hitsname:portNo</connection-url>

                          <driver>oracle</driver>

                          <pool>

                              <min-pool-size>1</min-pool-size>

                              <max-pool-size>15</max-pool-size>

                          </pool>

                          <security>

                                    <user-name>xxxxxx</user-name>

                                    <password>yyyyy</password>

                          </security>

                          <timeout>

                              <idle-timeout-minutes>0</idle-timeout-minutes>

                          </timeout>

                      </datasource>

       

      Timeouts:

       

      Use tryLock():

      0

       

      Blocking Timeout Millis:

      0

       

      Idle Timeout Minutes:

      0

       

      Set Tx Query Timeout:

      false

       

      Query Timeout:

      0

       

      Allocation Retry:

      0

       

      Allocation Retry Wait Millis:

      0

      Pool:

       

      Min Pool Size:

      1

       

      Max Pool Size:

      15

       

      Strict Minimum:

      false

       

      Prefill enabled:

      false

       

      Flush Strategy:

       

      Idle Timeout:

      0

       

      Track Statements:

      Validation:

       

      Valid Connection Checker:

       

      Check Valid Sql:

       

      Validate On Match:

      false

       

      Background Validation:

      false

       

      Validation Millis:

      0

       

      Stale Connection Checker:

       

      Exception Sorter:

      Please help on this issue.

       

      Thanks,
      Chary