Website | Docs | JDBC Docs | Community Slack

Kinetica JDBC Driver

• Overview
• Configure
• Connect
• Examples
• Documentation
• Support
• Contact Us

Overview

The Kinetica JDBC Driver supports connections from a wide array of JDBC-aware applications to the Kinetica database.

Ideally, the version of the driver must match that of the database; e.g., the 7.2 version of the driver is interoperable with any Kinetica 7.2.X.Y database. However, the 7.2 driver may be compatible with 7.1 database instances for most use cases.

Configure

Kinetica JDBC driver JAR:

kinetica-jdbc-7.2.<X>.<Y>-jar-with-dependencies.jar

Driver class:

com.kinetica.jdbc.Driver

Common Connection Parameters

For the full parameter set, see ODBC/JDBC Connection Guide.

Parameter	Description
URL	Kinetica connection URL; used in lieu of the default host/port configuration for SSL or failover connections
UID	Connection user ID
PWD	Connection user password
Timeout	Minutes to wait for a server response; no timeout is 0 (default)
RowsPerFetch	Number of rows to be requested in a query at a time; default is 10,000 rows

SSL Parameters

Parameter	Description
BypassSslCertCheck	Allow (1) or disallow (0) the Kinetica certificate host name and server host name to be different
SslCACertPassword	Password to the certificate store specified by either SslCACertPath or TrustedStorePath
SslCACertPath	Path to client's trust store, used to validate the certificate from the Kinetica server
TrustedStorePath	Path to client's trust store, used to validate the certificate from the Kinetica server (override for SslCACertPath parameter)

Connect

JDBC connection string:

jdbc:kinetica://<ip or hostname>:<port>[;<key1>=<value1>...]

jdbc:kinetica:URL=<connection URL>[;<key1>=<value1>...]

Examples

To connect to a local instance on the default port with username/password:

jdbc:kinetica://localhost:9191;UID=auser;PWD=apassword

To connect over SSL:

jdbc:kinetica:URL=https://12.34.56.78:8082/gpudb-0

To connect using HA, pass a comma-separated list of cluster URLs for the URL parameter, and the URL of the one to use first for the PrimaryURL parameter:

jdbc:kinetica:URL=http://kineticaA:9191,http://kineticaB:9191,http://kineticaC:9191;PrimaryURL=http://kineticaB:9191

Documentation

• Full Documentation
• ODBC/JDBC Connection Guide

Support

For bugs, please submit an issue on Github.

For support, you can post on stackoverflow under the kinetica tag or Slack.

Contact Us

• Ask a question on Slack: Slack
• Follow on GitHub: Follow @kineticadb
• Email us: [email protected]
• Visit: https://www.kinetica.com/contact/