Friday, December 1, 2023
HomeProgrammingThe JDBC Connection URLs and driver names of the preferred RDBMS

The JDBC Connection URLs and driver names of the preferred RDBMS


Want to hook up with your RDBMS with JDBC and don’t have the JDBC connection URL or driver title at hand? No downside, simply search for your RDBMS under:

// 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:skinny://<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:skinny:@<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>.<area>.redshift.amazonaws.com:5439/<database>"

// Snowflake
driver = "web.snowflake.shopper.jdbc.SnowflakeDriver";
url = "jdbc:snowflake://<server>.<area>.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 Anyplace
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/reminiscence/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

Please enter your comment!
Please enter your name here

- Advertisment -
Google search engine

Most Popular

Recent Comments