Opened 13 years ago
Closed 13 years ago
#591 closed defect (fixed)
Constant Validation Query "SELECT 1" breaks support for DB2 and Oracle
| Reported by: | mcr | Owned by: | fxp |
|---|---|---|---|
| Priority: | major | Milestone: | v2.7.0 |
| Component: | General | Version: | |
| Keywords: | Cc: |
Description
Oracle needs:
"select 1 from dual"
DB2 needs "select 1 from sysibm.sysdummy1"
All other dbs should work with "SELECT 1"
The attached patch adds an optional xml element <validationQuery> to config.xml. If no <validationQuery> element is specified, no query is used by the connection pool.
Attachments (1)
Change History (3)
by , 13 years ago
| Attachment: | validationQuery.patch added |
|---|
comment:1 by , 13 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
| Version: | v2.6.3 |
Note:
See TracTickets
for help on using tickets.
Patch file tested against trunk