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 |