#591: Constant Validation Query "SELECT 1" breaks support for DB2 and Oracle
---------------------+------------------------------------------------------
Reporter: mcr | Owner: geonetwork-devel@…
Type: defect | Status: new
Priority: major | Milestone: v2.7.0
Component: General | Version: v2.6.3
Keywords: |
---------------------+------------------------------------------------------
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.
--
Ticket URL: <http://trac.osgeo.org/geonetwork/ticket/591>
GeoNetwork opensource Developer website <http://sourceforge.net/projects/geonetwork/>
GeoNetwork opensource is a standards based, Free and Open Source catalog application to manage spatially referenced resources through the web. It provides powerful metadata editing and search functions as well as an embedded interactive web map viewer. This website contains information related to the development of the software.