Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.ocient.com/llms.txt

Use this file to discover all available pages before exploring further.

The JDBC driver can be executed in a command-line interface (CLI) mode or used directly in a program with standard JDBC methods. This example describes how to connect using the CLI mode. For details on using the JDBC driver in code, please see Establishing a Connection.

​
Step 1: Download the JDBC Driver

First, confirm the recommended version of the JDBC driver for your version of by finding it in Version Compatibility. Download the correct JDBC driver from the repository by clicking on your preferred version, then selecting view all, and finally downloading the JAR file that is labeled with the pattern ocient-jdbc4-<version number>-jar-with-dependencies.jar. Save this file to a convenient location on your client machine.

​
Step 2: Run the JDBC CLI Program

To run the JDBC CLI Program, you must have installed on your machine. For the version, see Version Compatibility. Next, run the following command to start the JDBC CLI Program. Assuming your JAR stored at ~/ocient-jdbc4-jar-with-dependencies.jar.
Shell
 java -classpath ~/ocient-jdbc4-jar-with-dependencies.jar com.ocient.cli.CLI
The system prompts you to enter the username and password.
Shell
 Username: test@system
 Password: fakepassword
Example Response:
Shell
 Ocient> _
The Ocient CLI prompt appears.

​
Step 3: Connect

To connect, enter the connection string to your SQL Nodes. SQL Nodes install by default with a self-signed TLS certificate for encryption by default, and a custom certificate can be present. Depending on the TLS configuration, you can use tls=unverified (default) or tls=on for the required setting. Assuming the standard port 4050, a self-signed certificate, and the SQL Node IP Address of 10.10.1.1, you can connect to the system database with the following connecting string:
Shell
 Ocient> connect to jdbc:ocient://10.10.1.1:4050/system;
Example Response:
Shell
 Connected to jdbc:ocient://10.10.1.1:4050/system
 Ocient> _
You are now connected and can execute queries based on your user’s permissions. Try running: select * from sys.tables; to see what tables are defined. For more details on using the JDBC driver and the CLI program, see the JDBC Manual.
The system cancels any queries made with the JDBC driver if you perform any of these actions:
  • Fetch the entire result set.
  • Close the connection.
  • Execute a new query on the same connection.
Connect to Ocient Ocient Integrations
Last modified on May 27, 2026