JAVA

The JDBC Connection URLs and driver names of the most popular RDBMS

Need to connect to your RDBMS with JDBC and don’t have the JDBC connection URL or driver name at hand? No problem, just look up your RDBMS below:

// BigQuery
driver = "com.simba.googlebigquery.jdbc42.Driver";
url = "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=<project-id>;OAuthType=0;OAuthServiceAcctEmail=<service-account>;OAuthPvtKeyPath=path-to-key.json";

// CockroachDB
driver = "org.postgresql.Driver";
url = "jdbc:postgresql://<host>/<database>";

// Db2
driver = "com.ibm.db2.jcc.DB2Driver";
url = "jdbc:db2://<host>:50000/<database>";

// Derby
driver = "org.apache.derby.jdbc.EmbeddedDriver";
url = "jdbc:derby:<path-to-database>;create=true";

// DuckDB
driver = "org.duckdb.DuckDBDriver";
url = "jdbc:duckdb:<path-to-database>";

// EXASOL
driver = "com.exasol.jdbc.EXADriver";
url = "jdbc:exa:<host>:9563;schema=<default-schema>";

// Firebird
driver = "org.firebirdsql.jdbc.FBDriver";
url = "jdbc:firebirdsql:<host>:<path-to-database>";

// H2
driver = "org.h2.Driver";
url = "jdbc:h2:<path-to-database>";

// HANA
driver = "com.sap.db.jdbc.Driver";
url = "jdbc:sap://<host>:39017";

// HSQLDB
driver = "org.hsqldb.jdbcDriver";
url = "jdbc:hsqldb:file:<path-to-database>";

// Ignite
driver = "org.apache.ignite.IgniteJdbcThinDriver";
url = "jdbc:ignite:thin://<host>";

// Informix
driver = "com.informix.jdbc.IfxDriver";
url = "jdbc:informix-sqli://<host>:9088/<database>:INFORMIXSERVER=informix";

// Ingres
driver = "com.ingres.jdbc.IngresDriver";
url = "jdbc:ingres://<host>:II7/<database>";

// MariaDB
driver = "org.mariadb.jdbc.Driver";
url = "jdbc:mariadb://<host>/<default-schema>";

// MemSQL
driver = "com.mysql.cj.jdbc.Driver";
url = "jdbc:mysql://127.0.0.1/<default-schema>";

// MySQL
driver = "com.mysql.cj.jdbc.Driver";
url = "jdbc:mysql://127.0.0.1/<default-schema>";

// Oracle
driver = "oracle.jdbc.OracleDriver";
url = "jdbc:oracle:thin:@<database>:1521/<SID>"

// PostgreSQL
driver = "org.postgresql.Driver";
url = "jdbc:postgresql://<host>/<database>";

// Redshift
driver = "com.amazon.redshift.jdbc.Driver";
url = "jdbc:redshift://<cluster-id>.<region>.redshift.amazonaws.com:5439/<database>"

// Snowflake
driver = "net.snowflake.client.jdbc.SnowflakeDriver";
url = "jdbc:snowflake://<server>.<region>.snowflakecomputing.com:443/?db=<database>&schema=<schema>";

// SQLite
driver = "org.sqlite.JDBC";
url = "jdbc:sqlite:<path-to-database>";

// SQL Server
driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
url = "jdbc:sqlserver://<host>:1433;databaseName=<database>";

// Sybase ASE
driver = "com.sybase.jdbc4.jdbc.SybDriver";
url = "jdbc:sybase:Tds:<host>:5000/<database>";

// Sybase SQL Anywhere
driver = "com.sybase.jdbc4.jdbc.SybDriver";
url = "jdbc:sybase:Tds:<host>:2638";

// Teradata
driver = "com.teradata.jdbc.TeraDriver";
url = "jdbc:teradata://<host>/DATABASE=<database>,DBS_PORT=1025"

// Trino
driver = "io.trino.jdbc.TrinoDriver";
url = "jdbc:trino://<host>:8080/memory/default";

// Vertica
driver = "com.vertica.jdbc.Driver";
url = "jdbc:vertica://<host>:5433/<database>";

// YugabyteDB
driver = "com.yugabyte.Driver";
url = "jdbc:yugabytedb://<host>/<database>";

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button