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.