Simple collection of common JDBC Drivers and JDBC URL’s, with username and password. If you find any mistakes please let me know.
MySQL
JDBC Driver:
1 | com.mysql.jdbc.Driver |
JDBC Url:
1 | jdbc:mysql://{{hostname}}:{{port}}/{{dataBaseName}}?user={{username}}&password={{password}} |
MariaDB
JDBC Driver:
1 | org.mariadb.jdbc.Driver |
JDBC Url:
1 | jdbc:mariadb://{{hostname}}:{{port}}/{{dataBaseName}}?user={{username}}&password={{password}} |
PostgreSQL
JDBC Driver:
1 | org.postgresql.Driver |
JDBC Url:
1 | jdbc:postgresql://{{hostname}}:{{port}}/{{dataBaseName}}?user={{username}}&password={{password}} |
Microsoft SQL Server
JDBC Driver:
1 | com.microsoft.sqlserver.jdbc.SQLServerDriver |
JDBC Url:
1 | jdbc:sqlserver://{{hostname}}:{{port}};databaseName={{dataBaseName}};user={{username}};password={{password}} |
Oracle Thin
JDBC Driver:
1 | oracle.jdbc.driver.OracleDriver |
JDBC Url:
1 | jdbc:oracle:thin:{{username}}/{{password}}@//{{hostname}}:{{port}}/{{serviceName}} |
Oracle OCI
JDBC Driver:
1 | oracle.jdbc.driver.OracleDriver |
JDBC Url:
1 | jdbc:oracle:oci:{{username}}/{{password}}@//{{hostname}}:{{port}}/{{serviceName}} |
IBM DB2 Express-C
JDBC Driver:
1 | com.ibm.db2.jcc.DB2Driver |
JDBC Url:
1 | jdbc:db2://{{hostname}}:{{port}}/{{dataBaseName}}:user={{username}};password={{password}} |
IBM DB2 Net
JDBC Driver:
1 | com.ibm.db2.jdbc.net.DB2Driver |
JDBC Url:
1 | jdbc:db2://{{hostname}}:{{port}}/{{dataBaseName}}:user={{username}};password={{password}} |
SAP HANA
JDBC Driver:
1 | com.sap.db.jdbc.Driver |
JDBC Url:
1 | jdbc:sap://{{hostname}}:{{port}}/?database={{dataBaseName}}&user={{username}}&password={{password}} |
Informix
JDBC Driver:
1 | com.informix.jdbc.IfxDriver |
JDBC Url:
1 | jdbc:informix-sqli://{{hostname}}:{{port}}/{{dataBaseName}}:INFORMIXSERVER={{serverName}};user={{username}};password={{password}} |
HSQLDB Mem
JDBC Driver:
1 | org.hsqldb.jdbc.JDBCDriver |
JDBC Url:
1 | jdbc:hsqldb:mem:{{dataBaseName}} |
HSQLDB File
JDBC Driver:
1 | org.hsqldb.jdbc.JDBCDriver |
JDBC Url:
1 | jdbc:hsqldb:file:{{dataBaseName}} |
H2
JDBC Driver:
1 | org.h2.Driver |
JDBC Url:
1 | jdbc:h2:mem:{{dataBaseName}} |
Derby
JDBC Driver:
1 | org.apache.derby.jdbc.EmbeddedDriver |
JDBC Url:
1 | jdbc:derby://{{hostname}}:{{port}}/{{dataBaseName}};create=true;user={{username}};password={{password}} |
Teradata
JDBC Driver:
1 | com.teradata.jdbc.TeraDriver |
JDBC Url:
1 | jdbc:teradata://{{hostname}}:{{port}}/database={{dataBaseName}},user={{username}},password={{password}} |