Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Won't Fix
-
1.2.1, 1.2.2, 1.3, 1.4
-
None
-
None
-
- 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
Description
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.