Skip to content

Instantly share code, notes, and snippets.

@ffbit

ffbit/dbcp-validation-queries.txt

Created August 14, 2015 17:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ffbit/0070faf4581e193550b1 to your computer and use it in GitHub Desktop.
Save ffbit/0070faf4581e193550b1 to your computer and use it in GitHub Desktop.
Download ZIP
DBCP's Database validationQuery notes
Raw
dbcp-validation-queries.txt
hsqldb - select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
Oracle - select 1 from dual
DB2 - select 1 from sysibm.sysdummy1
mysql - select 1
microsoft SQL Server - select 1 (tested on SQL-Server 9.0, 10.5 [2008])
postgresql - select 1
ingres - select 1
derby - values 1
H2 - select 1
Firebird - select 1 from rdb$database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment