$OMNISCI_PATH/bin/omniscijdbc-<major_version>.<minor_version>.<revision>.jar
$HEAVYAI_PATH/samples
jdbc:omnisci:<host>:[<keyvalue1>:<keyvalue2>:<keyvalue3>...][?<key1=value1>&<key2=value2>&<key3=value3>...]
DriverManager.getConnection
properties.jdbc:omnisci:<host_name>
must be defined in the main part of the connection string. host_name
- Name of the host. Must be defined in the main part of the connection string.port_num
- Port numberdb_name
- Name of the database.protocol:
<binary
|binary_tls
|http
|https
|https_insecure
>HTTPS_INSECURE
.
Note: Using HTTPS_INSECURE
is not recommended in a production environment.server_trust_store:
trust_store_path
- The path to a Java trust store holding the HEAVY.AI server public certificate.server_trust_store_pwd:
password
- The password to the trust store.pkiauth: true | false
- Enable PKI authentication. If true
:sslcert
parameter to supply a file containing the certificate.user
parameter and the password
parameters are ignored and should be blank.sslcert
certificate-path
- Path to the certificate and private key file, in PKCS12 format.sslkey
key-path
- Path to the SSL key.sslkey_password password
- Password for the SSL key defined in sslkey
key-path
.max_rows
max_rows
- The maximum number of rows to return.test_DB
using port 6274
with max_rows
set to 10000.test_DB
would be used, and if logging is turned on, the driver would issue a warning:host_name
followed by port_num
, followed by db_name
, and so on. All of these fields can be specified in this portion of the connection string; however to specify a max_rows
field this way, all the preceding values must also be specified. Empty fields are not allowed. In this case, consider using a Properties object or a the query string portion of the URL.clearWarnings
clearWarnings
, calling getWarnings
returns null until a new warning is reported for this connection object.close
createStatement
getCatalog
getMetaData
DatabaseMetaData
object, which contains metadata about the database for which this Connection object represents a connection. The metadata includes information about the database tables, supported SQL grammar, stored procedures, and the capabilities of this connection.getWarnings
isClosed
true
= connection closedfalse
= connection validisValid
true
= valid connectionfalse
= connection closedprepareStatement
acceptsURL
connect
getMajorVersion
getMinorVersion
getParentLogger
getPropertyInfo
jdbcCompliant