[jira] [Created] (DBCP-375) initialSize < minIdle => non-performing query plans are chosen

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (DBCP-375) initialSize < minIdle => non-performing query plans are chosen

Gilles (Jira)
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