[YugabyteDB Java Driver for YCQL (4.15)](https://github.com/yugabyte/cassandra-java-driver/tree/4.15.x) is based on [DataStax Java Driver 4.15](https://docs.datastax.com/en/developer/java-driver/4.15/) for [YCQL](../../../../api/ycql/) with additional [smart driver](../../smart-drivers-ycql/) features.
{{< note title="YugabyteDB Aeon" >}}
To use the driver's partition-aware load balancing feature in a YugabyteDB Aeon cluster, applications must be deployed in a VPC that has been peered with the cluster VPC so that they have access to all nodes in the cluster. For more information, refer to [Using YCQL drivers with YugabyteDB Aeon](../../smart-drivers-ycql/#using-ycql-drivers-with-yugabytedb-aeon).
{{< /note >}}
The following instructions show how you can build a Java application connected to YugabyteDB Aeon using the Yugabyte Java Driver for YCQL with SSL.
## Maven
To build a sample Java application with the [Yugabyte Java Driver for YCQL](https://github.com/yugabyte/cassandra-java-driver), add the following Maven dependency to your application:
```xml
com.yugabyte
java-driver-core
4.15.0-yb-1
```
## Create the sample Java application
### Prerequisites
This tutorial assumes that you have the following:
- A YugabyteDB Aeon cluster, with your database credentials (username and password)
- JDK version 1.8 or later
- Maven 3.3 or later
Add your computer to the cluster IP allow list. Refer to [IP allow lists](/stable/yugabyte-cloud/cloud-secure-clusters/add-connections/).
You also need to download and install your YugabyteDB Aeon cluster CA certificate and obtain the cluster connection parameters. Refer to [Get the cluster connection parameters](/stable/yugabyte-cloud/cloud-connect/connect-applications/#get-the-cluster-connection-parameters).
### Create the project's POM
Create a Project Object Model (POM) file, named `pom.xml`, and then copy the following content into it. The POM includes configuration information required to build the project.
```xml
4.0.0
com.yugabyte.sample.apps
hello-world
1.0
jar
1.8
1.8
com.yugabyte
java-driver-core
4.15.0-yb-1
org.apache.maven.plugins
maven-dependency-plugin
2.1
copy-dependencies
prepare-package
copy-dependencies
${project.build.directory}/lib
true
true
true
```
### Write a sample Java application
Create the appropriate directory structure as expected by Maven.
```sh
$ mkdir -p src/main/java/com/yugabyte/sample/apps
```
Copy the following contents into the file `src/main/java/com/yugabyte/sample/apps/YBCqlHelloWorld.java`.
```java
package com.yugabyte.sample.apps;
import java.io.FileInputStream;
import java.net.InetSocketAddress;
import java.security.KeyStore;
import java.security.cert.CertificateFactory;
import java.security.cert.X509Certificate;
import java.util.List;
import javax.net.ssl.SSLContext;
import javax.net.ssl.TrustManagerFactory;
import com.datastax.oss.driver.api.core.CqlSession;
import com.datastax.oss.driver.api.core.cql.ResultSet;
import com.datastax.oss.driver.api.core.cql.Row;
public class YBCqlHelloWorld {
// Load the cluster root certificate
private static SSLContext createSSLHandler(String certfile) {
try {
CertificateFactory cf = CertificateFactory.getInstance("X.509");
FileInputStream fis = new FileInputStream(certfile);
X509Certificate ca;
try {
ca = (X509Certificate) cf.generateCertificate(fis);
} catch (Exception e) {
System.err.println("Exception generating certificate from input file: " + e);
return null;
} finally {
fis.close();
}
// Create a KeyStore containing our trusted CAs
String keyStoreType = KeyStore.getDefaultType();
KeyStore keyStore = KeyStore.getInstance(keyStoreType);
keyStore.load(null, null);
keyStore.setCertificateEntry("ca", ca);
// Create a TrustManager that trusts the CAs in our KeyStore
String tmfAlgorithm = TrustManagerFactory.getDefaultAlgorithm();
TrustManagerFactory tmf = TrustManagerFactory.getInstance(tmfAlgorithm);
tmf.init(keyStore);
SSLContext sslContext = SSLContext.getInstance("TLS");
sslContext.init(null, tmf.getTrustManagers(), null);
return sslContext;
} catch (Exception e) {
System.err.println("Exception creating sslContext: " + e);
return null;
}
}
public static void main(String[] args) {
try {
if (args.length != 4) {
System.out.println("Usage YBCqlHelloWorld " +
" ");
System.exit(-1);
}
// Create a YCQL client.
CqlSession session = CqlSession
.builder()
.addContactPoint(new InetSocketAddress(args[0], 9042))
.withSslContext(createSSLHandler(args[1]))
.withAuthCredentials(args[2], args[3])
.withLocalDatacenter("datacenter1")
.build();
// Create keyspace 'ybdemo' if it does not exist.
String createKeyspace = "CREATE KEYSPACE IF NOT EXISTS ybdemo;";
session.execute(createKeyspace);
System.out.println("Created keyspace ybdemo");
// Create table 'employee', if it does not exist.
String createTable = "CREATE TABLE IF NOT EXISTS ybdemo.employee (id int PRIMARY KEY, " +
"name varchar, " + "age int, " + "language varchar);";
session.execute(createTable);
System.out.println("Created table employee");
// Insert a row.
String insert = "INSERT INTO ybdemo.employee (id, name, age, language)" +
" VALUES (1, 'John', 35, 'Java');";
session.execute(insert);
System.out.println("Inserted data: " + insert);
// Query the row and print out the result.
String select = "SELECT name, age, language FROM ybdemo.employee WHERE id = 1;";
ResultSet selectResult = session.execute(select);
List < Row > rows = selectResult.all();
String name = rows.get(0).getString(0);
int age = rows.get(0).getInt(1);
String language = rows.get(0).getString(2);
System.out.println("Query returned " + rows.size() + " row: " + "name=" + name +
", age=" + age + ", language: " + language);
// Close the client.
session.close();
} catch (Exception e) {
System.err.println("Error: " + e.getMessage());
}
}
}
```
Edit the `.withLocalDatacenter` line by replacing "datacenter1" with the LocalDatacenter from your cluster connection parameters.
You can also find the local data center name by running the following YCQL query from YugabyteDB Aeon Shell:
```sql
admin@ycqlsh:yugabyte> SELECT * FROM system.local;
```
### Add the root certificate to the project
To add the root certificate you downloaded to the application project, create a `resources` directory in your Java project.
```sh
$ mkdir -p src/main/resources
```
Then copy the root certificate `root.crt` into the `src/main/resources` directory.
### Build the project
To build the project, run the following `mvn package` command.
```sh
$ mvn package
```
You should see a `BUILD SUCCESS` message.
### Run the application
To use the application, run the following command.
```sh
$ java -cp "target/hello-world-1.0.jar:target/lib/*" \
com.yugabyte.sample.apps.YBCqlHelloWorld \
[HOST] [ROOT_CERT_PATH] [YCQL_USER] [YCQL_PASSWORD]
```
Replace the following command line variables with the appropriate connection parameters and database credentials:
| Variable | Description |
| :------- | :---------- |
| HOST | The hostname of your YugabyteDB Aeon cluster |
| ROOT_CERT_PATH | The path to root.crt |
| YCQL_USER | Your database username |
| YCQL_PASSWORD | Your database password |
For example:
```sh
$ java -cp "target/hello-world-1.0.jar:target/lib/*" \
com.yugabyte.sample.apps.YBCqlHelloWorld \
42424242-42d0-4c1a-b424-d42424ab2f42.aws.yugabyte.cloud \
src/main/resources/root.crt admin qwerty
```
You should see the following output:
```output
Created keyspace ybdemo
Created table employee
Inserted data: INSERT INTO ybdemo.employee (id, name, age, language) VALUES (1, 'John', 35, 'Java');
Query returned 1 row: name=John, age=35, language: Java
```