MarcyNunns

Tech Tips: Resolving Cassandra Database issue with LISA : Read a negative frame size

Discussion created by MarcyNunns Employee on Aug 28, 2015
Latest reply on Jun 10, 2016 by ok9999

Test environment of issue:

 

LISA 7.5.0

 

Using own JVM Java 1.7 Build 80

 

Cassandra database v 2.0 running on Linux system.


Copied the below jars to LISA_HOME\lib:

cassandra-jdbc-2.1.1.jar

apache-cassandra-clientutil-1.2.6.jar

apache-cassandra-thrift-1.2.6.jar

cassandra-all-1.2.9.jar

guava-15.0.jar

jackson-core-asl-1.9.2.jar

jackson-mapper-asl-1.9.2.jar

libthrift-0.7.0.jar

log4j-1.2.15.jar

slf4j-api-1.5.2.jar

slf4j-log4j12-1.5.2.jar

slf4j-simple-1.5.2.jar

 

Driver details:

org.apache.cassandra.cql.jdbc.CassandraDriver

 

Running a JDBC test step and getting this error on execution:


cassandra_jdbc_error.jpg


Was using port 9042 in connection string.  Resolved when using port 9160:


URL: jdbc:cassandra://{HOST}:9160/{DB}


Reference:


Cassandra Drivers and URL (http://www.dbschema.com/cassandra-jdbc-driver.html)

Driver Information :

Required File(s): cassandra-driver.jar

Java Driver Class: org.apache.cassandra.cql.jdbc.CassandraDriver

URL: jdbc:cassandra://{HOST}:9160/{DB}

Website: Cassandra  (http://cassandra.apache.org/)

 

Note: Realize database version jars and dlls can change at any time.

Outcomes