initialSize < minIdle => non-performing query plans are chosen
--------------------------------------------------------------
Key: DBCP-375
URL: https://issues.apache.org/jira/browse/DBCP-375
Project: Commons Dbcp
Issue Type: Bug
Affects Versions: 1.4, 1.3, 1.2.2, 1.2.1
Environment: * dhcp 1.2.1, pool 1.2 (issue also tested with latests
library version => still there)
* java 6
* oracle 10.2 and 11 (ojdbc 4 - 6)
* hibernate 2.1.8
Reporter: Patrick Hammer
We found a strange behaviour when setting initialSize=0 and minIdle=10:
* non-performing query plans are used on the DB
* correct query plans are used by "small" java app without dhcp and pool (or by
sqldeveloper)
Analysis:
* DB tracing showed no difference between the inputs of
performing/non-performing queries
* ojdbc tracing showed no difference neither
Work-around:
* set initialSize = minIdle, e.g., both to 10.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
