/
JDBC Snippets
JDBC Snippets
Typical JDBC URLs and validation Queries
The JDBC URL links usually refer to what we presume to be the most recent product version at the time we googled the links, earlier versions might not support all URL parameters.
Database | Driver class name | JDBC URL Example | JDBC URL Links | validation Query recommendation |
---|---|---|---|---|
Apache Derby | org.apache.derby.jdbc.EmbeddedDriver | jdbc:derby:[subsubprotocol:]MYDATABASE | Derby JDBC database connection URL | |
MySQL | com.mysql.jdbc.Driver | jdbc:mysql://myserver:3306/MYDATABASE | Connector/J Reference | SELECT 1 |
MS SQL Server | com.microsoft.sqlserver.jdbc.SQLServerDriver | jdbc:sqlserver://myserver:1433;databaseName=MYDATABASE | Building the Connection URL | SELECT 1 |
Oracle | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@myserver:1521:MYTNS | Oracle JDBC Driver and URL Information (@razorsql.com) | SELECT SYSDATE FROM DUAL |
PostgreSQL | org.postgresql.Driver | jdbc:postgresql://myserver:5432/MYDATABASE | SELECT 1 | |
SQLite | org.sqlite.JDBC | jdbc:sqlite:/var/foo/MYDATABASE.db | - |
, multiple selections available,
Related content
Full list of JDBC Provider Configuration Keys
Full list of JDBC Provider Configuration Keys
More like this
GoGo Jdbc Commands
GoGo Jdbc Commands
More like this
Generator Usage
Generator Usage
More like this
SSH-Tunneling hints
SSH-Tunneling hints
More like this
Confluence & Jira migrated to PostgreSQL and upgraded
Confluence & Jira migrated to PostgreSQL and upgraded
More like this
Scripting handwork rg. PostgreSQL bug CVE-2017-7547
Scripting handwork rg. PostgreSQL bug CVE-2017-7547
More like this