JDBC List of common JDBC Drivers and URL's

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}}