Cassandra JDBC Driver

This is a fork of the Cassandra JDBC Driver codenamed “Twig”. The purpose of this modification is to provide a JDBC compliant driver for Cassandra that has functional query support for common JDBC development tools (DbVisualizer, IntelliJ, etc.). While the original driver is capable it lacks a few key things:

Cassandra 2.x / 3.x

Table name support for MetaData

ResultSet support for LIST, SET or MAP via JDBC getObject()

Rendering UDT fields

Encrypted connections

JUnit tests for these things

Whatever else comes along…

This fork is hosted on Github as a result of the demise of Google Code:

Packages are provided here for easy download and installation, all of the necessary dependencies are bundled so it is painless to configure your favorite query tool. Instructions for setting up DbVisualizer are included below.

For enabling encryption, both the trustStore and trustPass need to be specified on the JDBC properties. For an example of this, refer to the documentation on Github.

DbVisualizer

Create new Database Driver. Select Tools – Driver Manager and press the “Create new driver” button in the toolbar. The URL format should be jdbc:cassandra://<server>:<port>/<database>. Update the Driver File Paths to reference the Cassandra Twig driver (eg: cassandra-twig-jdbc-2.1.1.jar).Close the Driver Manager window.

Create a Connection. Select the “Create a new Connection” button in the Databases tab. When prompted, choose “No Wizard”. Complete the form as follows.Replace the host and keyspace in the “Database URL” with your own settings. Authentication is not currently supported.

Test the Connection. Open the database and browse the available keyspaces. Expand a keyspace and browse the data in any of your tables.