Drivers and Extensions

Database

Driver

Extension

Notes

Amazon Redshift

File: redshift-jdbc<version>.jar
Class: com.amazon.redshift.jdbc42.Driver
Example: jdbc:redshift://endpoint:port/database
Download: https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html

NA

NA

Apache Derby

File: derbytools.jar
Class: org.apache.derby
Example: jdbc:derby://localhost:1527/MYDATABASE;create=true
Download: https://db.apache.org/derby/derby_downloads.html

NA

NA

Cassandra

File: CassandraJDBC<version>.jar
Class: com.simba.cassandra.jdbc42.Driver
Example: jdbc:cassandra://localhost:9042/myKeyspace;DefaultKeyspace=myKeyspace
Download: https://downloads.datastax.com/#odbc-jdbc-drivers

NA

NA

Cassandra on Datastax Astra

File: CassandraJDBC<version>.jar
Class: com.simba.cassandra.jdbc42.Driver
Example: jdbc:cassandra://host:port;DefaultKeyspace=keyspace;AuthMech=2;UID=username;PWD=password;SecureConnectionBundlePath=path/to/secure-connect-database_name.zip;TunableConsistency=6
Download: https://downloads.datastax.com/#odbc-jdbc-drivers

NA

NA

Cloud Spanner

Example: jdbc:cloudspanner:/projects/<project>/instances/<instance>/databases/<database>
Download: https://github.com/cloudspannerecosystem/liquibase-spanner

liquibase-spanner-version-all.jar

Includes extension and driver.

COCKROACHDB on prem

File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: jdbc:postgresql://localhost:26257/database?ssl=true&sslmode=require&sslrootcert=/full-path/certs/ca.crt&sslkey=/full-ath/certs/client.user.key.pk8&sslcert=/full-path/certs/client.user.crt
Download: https://jdbc.postgresql.org/download.html

NA

TLS certificate workflow is preferred. The following option is insecure:

jdbc:postgresql://localhost:26257/dev

COCKROACHDB Cloud

File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: jdbc:postgresql://liquibase-3r8.aws-us-east-2.cockroachlabs.cloud:26257/defaultdb?sslmode=verify-full&sslrootcert=liquibase-ca.crt
Download: https://jdbc.postgresql.org/download.html

NA

Requires TLS certificate workflow.

Firebird

File: jaybird-full-<version>.jar
Class: org.firebirdsql.jdbc.FBDriver
Example: jdbc:firebirdsql://<IP/host>:<port>//<server/path/to/database>
Download: https://github.com/FirebirdSQL/jaybird/releases/download/v3.0.6/Jaybird-3.0.6-JDK_1.8.zip

NA

NA

H2

File: h2-<version>.jar
Class: NA
Example:

  • Memory: jdbc:h2:tcp://localhost:9090/mem:dev
  • File: jdbc:h2:file:C:/tools/LB_DBs/H2Example/h2tutorial

Download: Included with Liquibase in <install-directory/lib>

NA

Included with Liquibase.

Hibernate

File: h2-<version>.jar
Class: liquibase.ext.hibernate.database.connection.HibernateDriver
Example: hibernate:ejb3:com.liquibase.hibernate.tutorial.jpa
Download: Included with Liquibase in <install-directory/lib>

https://github.com/liquibase/liquibase-hibernate/releases

NA

Hive

File: HiveJDBC<version>.jar
Class: com.cloudera.hive.jdbc41.HS2Driver
Example: jdbc:hive2://localhost:10000/hive_test;UID=eselyavka;UseNativeQuery=1
Download: https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-2.html

https://github.com/eselyavka/liquibase-impala

NA

HSQLDB

File: hsqldb.jar
Class: org.hsqldb.jdbcDriver
Example: jdbc:hsqldb:hsql://192.168.1.15:9001/<db-name>
Download: Included with HSQL download fromhttps://sourceforge.net/projects/hsqldb/files/

NA

NA

IBM DB2 LUW

File: db2jcc<version>.jar
Class: com.ibm.db2.jcc.DB2Driver
Example: jdbc:db2://<server-name>:<port>/<db-name>
Download: https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads

NA

NA

IBM DB2 on Z

File: db2jcc<version>.jar
Class: com.ibm.db2.jcc.DB2Driver
Example: jdbc:db2://<host-IP-address>:<port>/<db-name>:retrieveMessagesFromServerOnGetMessage=true;emulateParameterMetaDataForZCalls=1;
Download: https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads

NA

Requires IBM license file db2jcc_license_cisuz.jar.

Impala

File: ImpalaJDBC<version>.jar
Class: com.cloudera.impala.jdbc41.Driver
Example: jdbc:impala://localhost:21050/impala_test
Download: https://www.cloudera.com/downloads/connectors/impala/jdbc/2-6-4.html

https://github.com/eselyavka/liquibase-impala

NA

Informix

File: jdbc-<version>.jar
Class: com.informix.jdbc.IfxDriver
Example: jdbc:informix-sqli://localhost:9088/dbname:INFORMIXSERVER=dbserver
Download: https://mvnrepository.com/artifact/com.ibm.informix/jdbc

NA

Requires Informix database in ANSI mode to enable implicit transactions with statements like the following example:

CREATE DATABASE [ansiDatabase] WITH LOG MODE ANSI;

Interbase

File: interclient.jar
Class: interbase.interclient.Driver
Example: jdbc:interbase://localhost:3050/interbase/testdb.ib
Download: Downloaded with Interbase from https://www.embarcadero.com/products/interbase/downloads

https://github.com/Gtunali/Liqubase-interbase/blob/master/jar/liquibase-interbase-1.2.0.jar

NA

MariaDB, skySQL, or MariaDB AWS RDS

File: mariadb-java-client-<version>.jar
Class: org.mariadb.jdbc.Driver
Example: jdbc:mariadb://<host>:<port>/<dbname>
Download: https://mariadb.com/kb/en/about-mariadb-connector-j/

NA

Select the Java 8 connector/j.

MaxDB

File: sapdbc.jar
Class: com.sap.dbtech.jdbc.DriverSapDB
Example: jdbc:sapdb://localhost:7200/MaxDB1
Download: https://maxdb.sap.com/

https://github.com/liquibase/liquibase-maxdb/releases

To view installed database software packages, including JDBC drivers, run the following command:

sdbregview -l

MongoDB

File: mongo-java-driver-<version>.jar
Class: NA
Example: mongodb://hostname:27017/<db-name>
Reference: https://docs.mongodb.com/manual/reference/connection-string/
Download: https://repo1.maven.org/maven2/org/mongodb/mongo-java-driver

https://github.com/liquibase/liquibase-mongodb/releases/

NA

MSSQL

File: mssql-jdbc-<version>.jre-<version>.jar
Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Example: jdbc:sqlserver://<host>:<port>/<db-name>;
Note: Requires semicolon at end.
Download: https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server

NA

NA

MySQL

File: mysql-connector-java-<version>.jar
Class: NA
Example: jdbc:mysql://<servername>:<port>/<dbname>
Download: https://dev.mysql.com/downloads/connector/j/

NA

NA

Oracle

File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
Example: jdbc:oracle:thin:@<host>:<port>:<dbname>
Download: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

NA

For information about Kerberos and TNS connections, see Connecting to an Oracle Database with Liquibase via Kerberos and Active Directory.

Oracle ATP & ADW

File: ojdbc<version>.jar
Class: oracle.jdbc.OracleDriver
Example: jdbc:oracle:thin:@<database_name>_high?TNS_ADMIN=/path/to/Wallet_<database_name>
Download: https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html

NA

Requires a configured wallet. To view an example, see Using Liquibase with Oracle ATP and ADW.

Postgres

File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: jdbc:postgresql://<host>:<port>/<dbname>
Download: https://jdbc.postgresql.org/download.html

NA

NA

SAP HANA

File: ngdbc-<version>.jar
Class: com.sap.db.jdbc.Driver
Example: jdbc:sap://localhost:30013/?databaseName=mydatabase&encrypt=true
Download: https://mvnrepository.com/artifact/com.sap.cloud.db.jdbc/ngdbc

https://github.com/liquibase/liquibase-hanadb/releases

NA

Snowflake

File: snowflake-jdbc-<version>.jar
Class: net.snowflake.client.jdbc.SnowflakeDriver
Example: jdbc:snowflake://<account_ID>.snowflakecomputing.com/?<connection_params>
Download: https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc

https://github.com/liquibase/liquibase-snowflake/releases

Requires additional files if using > 128 bit keys. For more information, see Using Liquibase with Snowflake.

SQLite

File: sqlite-jdbc-<version>.jar
Class: org.sqlite.JDBC
Example: jdbc:sqlite:example.db
Download: https://github.com/xerial/sqlite-jdbc

NA

NA

Sybase Anywhere

File: jtds-<version>.jar
Class: net.sourceforge.jtds.jdbc.Driver
Example: jdbc:jtds:sybase://localhost:5002/<db-name>
Download: https://mvnrepository.com/artifact/net.sourceforge.jtds/jtds

NA

NA

Teradata

File: terajdbc<version>.jar
Class: com.teradata.jdbc.TeraDriver
Example: jdbc:teradata://hostname/DATABASE=<db-name>
Download: https://downloads.teradata.com/download/connectivity/jdbc-driver

https://github.com/liquibase/liquibase-teradata/releases

NA

Vertica

File: vertica-jdbc-<version>.jar
Class: com.vertica.jdbc.Driver
Example: jdbc:vertica://localhost:5433/docker
Download: https://www.vertica.com/download/vertica/client-drivers/

https://github.com/liquibase/liquibase-vertica/releases

NA

VoltDB

File: jdbcdriver.jar
Class: org.voltdb.jdbc.Driver
Example: jdbc:voltdb://<server>:<port>
Download: https://mvnrepository.com/artifact/org.voltdb/voltdbclient/9.2.2

https://github.com/arun0009/liquibase-voltdb/tree/master/target

NA

YugabyteDB

File: postgresql-<version>.jar
Class: org.postgresql.Driver
Example: jdbc:postgresql://<host>:<port>/<db-name>
Download: https://jdbc.postgresql.org/download.html

NA

NA

Related links