datagrip/cassandra-jdbc-driver

Forked from https://bitbucket.org/dbschema/cassandra-jdbc-driver/

cassandra-jdbc-driver's Issues

SSL Clusters

@ignatov @kassak @tjlee @leo-from-spb @dprutean
I've added a PR #1 to enable connections to SSL enabled Cassandra clusters.

Implement methods of `java.sql.DatabaseMetaData` to enable `introspect using JDBC metadata` option in DataGrip

Methods that should be implemented:

• getSchemas
• getTables
• getColumns

Implementation should retrieve needed information from native Cassandra driver and wrap it in some ResultSet implementation (maybe it will be possible to use com.dbschema.CassandraResultSet)

Connection.close() does not work

Connection.close() does not work with the v1.3.5 driver.

// test code
public static void main(String[] args) {
try {
Statement stmt = null;

		ResultSet rs = null;

		String url = "jdbc:cassandra://127.0.0.1:9042/cycling";
		String usr = "cassandra";
		String pwd = "cassandra";

		Class.forName("com.dbschema.CassandraJdbcDriver");

		// -- 1
		Connection conn = DriverManager.getConnection(url, usr, pwd);
		String sql = "SELECT * FROM system_schema.tables";
		
		System.out.println(sql);
		
		stmt = conn.createStatement();
		rs = stmt.executeQuery(sql);
		
		int columnCnt = rs.getMetaData().getColumnCount();
		for(int i=0; i<columnCnt; i++) {
			System.out.println(rs.getMetaData().getColumnLabel(i+1) + ": " + rs.getMetaData().getColumnTypeName(i+1));
		}
		
		System.out.println("-----------------------");
		while (rs.next()) {
			for(int i=0; i<columnCnt; i++) {
				System.out.print(rs.getString(i+1) + ":" );
			}
			System.out.println();
			System.out.println("================");
		}

		rs.close();
		stmt.close();
		conn.close();
	} catch(Exception e) {
		e.printStackTrace();
	}
	
	test2();
}

Please upgrade the underlying JDBC driver

https://mvnrepository.com/artifact/com.datastax.cassandra/cassandra-driver-core

Note: This artifact was moved to:
com.datastax.oss » java-driver-core

The latest release is 4.17 (Jul 2023) vs 3.6 (Aug 2018) currently used:

cassandra-jdbc-driver/build.gradle

Line 30 in 35c7b59

compile group: 'com.datastax.cassandra', name: 'cassandra-driver-core', version: '3.6.0'

My motivation: Yugabyte's Cassandra compatibility layer doesn't play well with Jetbrains IDE