JDBC URL Formats List
This here is a list of JDBC driver class names and URL formats for some popular databases.
| Database | JDBC URL Format | 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.
Need a quick edit on the go? Download for iOS
