Database Validation Query: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<source lang="sql"> SELECT 1 --microsoft sql server (tested on sql-server 9.0, 10.5 [2008]) SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS -- hsqldb SELECT 1 FROM sysibm.sysdum...") |
No edit summary |
||
Line 2: | Line 2: | ||
SELECT 1 --microsoft sql server (tested on sql-server 9.0, 10.5 [2008]) | SELECT 1 --microsoft sql server (tested on sql-server 9.0, 10.5 [2008]) | ||
SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS -- hsqldb | SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS -- hsqldb | ||
SELECT 1 FROM rdb$database --firebird | |||
SELECT 1 FROM sysibm.sysdummy1 --db2 | SELECT 1 FROM sysibm.sysdummy1 --db2 | ||
SELECT 1 FROM dual -- oracle | SELECT 1 FROM dual -- oracle | ||
SELECT 1 -- postgresql | SELECT 1 -- postgresql | ||
SELECT 1 -- ingres | SELECT 1 -- ingres | ||
SELECT 1 -- mysql | SELECT 1 -- mysql | ||
VALUES 1 -- derby | VALUES 1 -- derby | ||
SELECT 1 -- h2 | SELECT 1 -- h2 | ||
</source> | </source> | ||
==References== | ==References== | ||
* [https://stackoverflow.com/questions/10684244 DBCP Database Validation Query] | * [https://stackoverflow.com/questions/10684244 DBCP Database Validation Query] |
Latest revision as of 21:04, 18 September 2019
SELECT 1 --microsoft sql server (tested on sql-server 9.0, 10.5 [2008])
SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS -- hsqldb
SELECT 1 FROM rdb$database --firebird
SELECT 1 FROM sysibm.sysdummy1 --db2
SELECT 1 FROM dual -- oracle
SELECT 1 -- postgresql
SELECT 1 -- ingres
SELECT 1 -- mysql
VALUES 1 -- derby
SELECT 1 -- h2