Connection Pool issue in JBoss-eap.6.4
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