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>";

We will be happy to hear your thoughts

Leave a reply

Som2ny Network
Logo
Register New Account
Compare items
  • Total (0)
Compare
0
Shopping cart