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