Drivers
RIOT-X relies on JDBC to interact with databases. It includes JDBC drivers for the most common database systems:
- Db2
-
jdbc:db2://host:port/database - MySQL
-
jdbc:mysql://[host]:[port][/database][?properties] - Oracle
-
jdbc:oracle:thin:@myhost:1521:orcl - Postgres
-
jdbc:postgresql://host:port/database(Driver version: 42.7.8) - Snowflake
-
jdbc:snowflake://<account_identifier>.snowflakecomputing.com/?<connection_params> - SQL Server
-
jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
|
The included PostgreSQL JDBC driver (version 42.7.8) is compatible with PostgreSQL 8.2 and later, and is also used for Databricks Lakebase connectivity. For Lakebase, ensure you use driver version 42.7.6 or later due to a critical bug fix (PR #3509). |
|
For non-included databases or to use a different driver version, place the JDBC driver JAR file in the |
