A Comprehensive List of JDBC Connection Strings
This here is a list of JDBC driver class names and connection strings for some popular databases.
| Database | JDBC Connection String | Driver Name |
|---|---|---|
| DB2 | jdbc:db2://HOST:PORT/DATABASE | com.ibm.db2.jcc.DB2Driver |
| IBM Informix® | jdbc:informix-sqli://HOST:PORT/DATABASE: informixserver=IBM Informix instance name;user=user_name; password=password | com.informix.jdbc.IfxDriver |
| Microsoft SQL Server | jdbc:microsoft:sqlserver://HOST:PORT;databaseName=DATABASE; SelectMethod=SELECT_MODE | com.microsoft.jdbc.sqlserver.SQLServerDriver |
| MySQL | jdbc:mysql://HOST:PORT/DATABASE | com.mysql.jdbc.Driver |
| MariaDB | jdbc:mariadb://HOST:PORT/DATABASE | org.mariadb.jdbc.Driver |
| Postgresql | jdbc:postgresql://HOST:PORT/DATABASE | org.postgresql.Driver |
| Netezza® | jdbc:netezza://HOST:PORT/DATABASE | org.netezza.Driver |
| Oracle Thin | jdbc:oracle:thin@HOST:PORT:DATABASE | oracle.jdbc.driver.OracleDriver |
| Oracle OCI | jdbc:oracle:oci:@DATABASE | oracle.jdbc.OracleDriver |
| Sybase | jdbc:sybase:Tds:HOST:PORT/DATABASE | com.sybase.jdbc3.jdbc.SybDriver |
| Teradata | jdbc:teradata://HOST/DBS_PORT=PORT/ DATABASE=DATABASE/CHARSET=UTF8,COMPAT_DBS=true | com.ncr.teradata.TeraDriver |
Need a good GUI tool for databases? TablePlus provides a native client that allows you to access and manage Oracle, MySQL, SQL Server, PostgreSQL, and many other databases simultaneously using an intuitive and powerful graphical interface.
Not on Mac? Download TablePlus for Windows.
On Linux? Download TablePlus for Linux
Need a quick edit on the go? Download TablePlus for iOS
