0 Replies Latest reply on Nov 8, 2017 7:02 AM by sujatha ganeshan

    Jboss EAP 7.0 : Database Connection leak issue with jboss

    sujatha ganeshan Newbie

      I am facing connection leak issue in Rest web service with more transaction than max-pool-size.

       

      Each transaction have 2 connections and closed in finally block properly.

       

      Once per transaction is completed, the same connection not moved to Connection Pool and this is available in "In Use"  count. 

       

      Jboss is created new connection for each transaction, but not utilized previous created connection.

       

      PoolConfiguration:

        MinSize: 1

        InitialSize: 1

        MaxSize: 10

        BlockingTimeout: 30000

        IdleTimeoutMinutes: 1

       

      Available (0):

      InUse (10):

      1df1f351 (NORMAL)           --------------> Created for Transaction 1  -  Not released

        638c4b28 (NORMAL)        --------------> Created for Transaction 2

        6576c34e (NORMAL)        --------------> Created for Transaction 3

        12a5b4de (NORMAL)        --------------> Created for Transaction 4

        b2a90a5 (NORMAL)

        31d60be6 (NORMAL)

        63e4af48 (NORMAL)

        7110be7e (NORMAL)

        3cfd1bd1 (NORMAL)

        4fea88f (NORMAL)

       

      After 11th transaction, I am getting below error

           javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/jdbc/Testdb1

           javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection