The JDBC Connection URLS and Driver Names of the Most Popular RDBMS

Need to Connect to your RDBMS with JDBC and Don’t 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=;OAuthType=0;OAuthServiceAcctEmail=;OAuthPvtKeyPath=path-to-key.json";

// CockroachDB
driver = "org.postgresql.Driver";
url = "jdbc:postgresql:///";

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

// Derby
driver = "org.apache.derby.jdbc.EmbeddedDriver";
url = "jdbc:derby:;create=true";

// DuckDB
driver = "org.duckdb.DuckDBDriver";
url = "jdbc:duckdb:";

// EXASOL
driver = "com.exasol.jdbc.EXADriver";
url = "jdbc:exa::9563;schema=";

// Firebird
driver = "org.firebirdsql.jdbc.FBDriver";
url = "jdbc:firebirdsql::";

// H2
driver = "org.h2.Driver";
url = "jdbc:h2:";

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

// HSQLDB
driver = "org.hsqldb.jdbcDriver";
url = "jdbc:hsqldb:file:";

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

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

// Ingres
driver = "com.ingres.jdbc.IngresDriver";
url = "jdbc:ingres://:II7/";

// MariaDB
driver = "org.mariadb.jdbc.Driver";
url = "jdbc:mariadb:///";

// MemSQL
driver = "com.mysql.cj.jdbc.Driver";
url = "jdbc:mysql://127.0.0.1/";

// MySQL
driver = "com.mysql.cj.jdbc.Driver";
url = "jdbc:mysql://127.0.0.1/";

// Oracle
driver = "oracle.jdbc.OracleDriver";
url = "jdbc:oracle:thin:@:1521/"

// PostgreSQL
driver = "org.postgresql.Driver";
url = "jdbc:postgresql:///";

// Redshift
driver = "com.amazon.redshift.jdbc.Driver";
url = "jdbc:redshift://..redshift.amazonaws.com:5439/"

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

// SQLite
driver = "org.sqlite.JDBC";
url = "jdbc:sqlite:";

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

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

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

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

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

// Vertica
driver = "com.vertica.jdbc.Driver";
url = "jdbc:vertica://:5433/";

// YugabyteDB
driver = "com.yugabyte.Driver";
url = "jdbc:yugabytedb:///";

Ramesh Ghorai is the founder of www.livenewsblogger.com, a platform dedicated to delivering exclusive live news from across the globe and the local market. With a passion for covering diverse topics, he ensures readers stay updated with the latest and most reliable information. Over the past two years, Ramesh has also specialized in writing top software reviews, partnering with various software companies to provide in-depth insights and unbiased evaluations. His mission is to combine news reporting with valuable technology reviews, helping readers stay informed and make smarter choices.

Leave a Comment

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

Scroll to Top