Drivers#
Constants for the provided JDBC drivers.
To use another JDBC driver, add its JAR to the extra_jars
.
Example
Storing user content in Google BigQuery:
>>> import glob
>>> from atoti_jdbc import UserContentStorageConfig
>>> user_content_storage_config = UserContentStorageConfig(
... "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=PROJECT_ID;OAuthType=0;OAuthServiceAcctEmail=EMAIL_OF_SERVICEACCOUNT;OAuthPvtKeyPath=path/to/json/keys;",
... driver="com.simba.googlebigquery.jdbc42.Driver",
... )
>>> session_config = tt.SessionConfig(
... extra_jars=glob.glob("./odbc_jdbc_drivers/*.jar"),
... user_content_storage=user_content_storage_config,
... )
- atoti_jdbc.driver.H2_DRIVER = 'org.h2.Driver'#
H2 driver.
- atoti_jdbc.driver.IBM_DB2_DRIVER = 'com.ibm.db2.jcc.DB2Driver'#
IBM Db2 driver.
- atoti_jdbc.driver.MARIADB_DRIVER = 'org.mariadb.jdbc.Driver'#
MariaDB driver.
- atoti_jdbc.driver.MSSQL_DRIVER = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'#
Microsoft SQL Server driver.
- atoti_jdbc.driver.MYSQL_DRIVER = 'com.mysql.cj.jdbc.Driver'#
MySQL driver.
- atoti_jdbc.driver.ORACLE_DRIVER = 'oracle.jdbc.OracleDriver'#
Oracle driver.
- atoti_jdbc.driver.POSTGRESQL_DRIVER = 'org.postgresql.Driver'#
PostgreSQL driver.