JDBC Snippets
Version 1.1 by christoph_lechleitner@iteg_at on 2013-07-09 02.50:58
Typical JDBC URLs and validation Queries
Database | JDBC URL Example | validation Query recommendation |
|---|---|---|
MySQL | jdbc:mysql://myserver:3306/MYDATABASE | SELECT 1 |
MS SQL Server | jdbc:sqlserver://myserver:1433;databaseName=MYDATABASE | SELECT 1 |
Oracle | jdbc:oracle:thin:@10.1.2.3:1521:XE | SELECT SYSDATE FROM DUAL |
PostgreSQL |
|
|
SQLite |
|
|