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