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