Skip to content

Latest commit

 

History

History
121 lines (78 loc) · 3.88 KB

README.md

File metadata and controls

121 lines (78 loc) · 3.88 KB
Raw

Kinetica Logo

Website | Docs | JDBC Docs | Community Slack

Kinetica JDBC Driver

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

Support

For bugs, please submit an issue on Github.

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

Contact Us