> ## 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.

# Connect Using JDBC

export const Ocient = "Ocient®";

export const Maven = "Apache® Maven™";

export const Java = "Java®";

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](https://docs.oracle.com/javase/tutorial/jdbc/basics/connecting.html).

## Step 1: Download the JDBC Driver

First, confirm the recommended version of the JDBC driver for your version of {Ocient} by finding it in [Version Compatibility](/version-compatibility). Download the correct JDBC driver from the {Maven} [repository](https://mvnrepository.com/artifact/com.ocient/ocient-jdbc4) 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 {Java} installed on your machine. For the version, see [Version Compatibility](/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 Shell theme={null}
 java -classpath ~/ocient-jdbc4-jar-with-dependencies.jar com.ocient.cli.CLI
```

The system prompts you to enter the username and password.

```shell Shell theme={null}
 Username: test@system
 Password: fakepassword
```

**Example Response:**

```shell Shell theme={null}
 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 Shell theme={null}
 Ocient> connect to jdbc:ocient://10.10.1.1:4050/system;
```

**Example Response:**

```shell Shell theme={null}
 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](/jdbc-manual).

<Info>
  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.
</Info>

## Related Links

[Connect to Ocient](/connect-to-ocient)

[Ocient Integrations](/ocient-integrations)