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.