How to connect to Cassandra Cloud AstraDb with JDBC ?

About

This article shows you how you can connect to an AstraDb database with Jdbc. ¹⁾

Steps

Download the Cassandra Astra Driver

Download the JDBC driver at datastax ²⁾

Optional for Idea - Create a new driver

Create a new driver with the following properties:

• Driver File: CassandraJDBC42.jar
• Driver Class: com.simba.cassandra.jdbc42.Driver

Auth

From the Astra DB console:

• Download the Secure Connect Bundle that contains:
  • the server certificate
  • the client certificate
  • the database hostname and port
• Create a token

Connect String

Create a new connection with the following JDBC URL

jdbc:cassandra://keyspace;DefaultKeyspace=keyspace;AuthMech=2;UID=token;PWD=<ApplicationToken>;SecureConnectionBundlePath=<PATH TO YOUR SECURE CONNECT BUNDLE>;TunableConsistency=6

where:

• keyspace is the keyspace you want to connect to (Optional)
• DefaultKeyspace is the default keyspace (Optional)
• AuthMech: Specifies whether the driver connects to a Cassandra or Astra DB database and whether the driver authenticates the connection.
• ApplicationToken: The generated from Astra DB console.
• SecureConnectionBundlePath: Path to where your downloaded Secure Connect Bundle is located.
• TunableConsistency: Specifies Cassandra replica or the number of Cassandra replicas that must process a query for the query to be considered successful.

Example on Idea: