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

Snowflake

jdbc:snowflake://<account_identifier>.snowflakecomputing.com/?<connection_params>

SQL Server

jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

For non-included databases, place the JDBC driver jar under the lib directory