RazorSQL - Not able to connect to Cassandra DB

Question

I am trying to connect to CassandraDB through RazorSQL. I am new to RazorSQL.

Steps followed:

1. In the topmenu --> Connections --> Add connection profile --> Entering all the details in the popmenu which appears (driver location, host, port number, etc.)

I tried with AutoDownload Driver option in RazorSQL, and also tried with various Cassandra JDBC Drivers.

cassandra-jdbc-1.2.5, cassandra-jdbc-2.1.1, CassandraJdbcDriver.zip, DataStaxCassandraODBC32.

I am getting this error msg:

ERROR: An error occurred while trying to make a connection to the database:

JDBC URL: jdbc:cassandra://88.198.37.102:9042

org.apache.thrift.transport.TTransportException: Read a negative frame size (-2113929216)!

Can anyone help me how to connect to Cassandra DB using this.. thank you very much in advance.

Answer 1

I'm not familiar with RazorSQL and can't see the dialog, but the error message indicates that you are trying to connect a thrift client to the Cassandra native protocol default port (9042).

You should be able to connect to the Thrift server on 9160. Depending on your version of Cassandra, you may need to enable it in cassandra.yaml:

start_rpc: true