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