Service Virtualization

Expand all | Collapse all

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

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

    Posted 08-28-2015 02:28 PM

    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.



  • 2.  Re: Tech Tips: Resolving Cassandra Database issue with LISA : Read a negative frame size

    Posted 06-10-2016 02:36 PM

    Will the list change for DEVTEST 8.4? I tried pasting these files to ${LISA_HOME}\hotDeploy as well as ${LISA_HOME}\lib $ {LISA_HOME}\lib\shared

     

    but the connection to db still fails due to no class found. I am running the test via ANT. The connection from the workstation works as see the class in the gui via the classpath navigator pane.

     

     

    This is a part of the stack trace:

     

    STACK TRACE

    java.lang.ClassNotFoundException: org.apache.cassandra.cql.jdbc.CassandraDriver

    at java.net.URLClassLoader$1.run(Unknown Source)

    at java.net.URLClassLoader$1.run(Unknown Source)

    at java.security.AccessController.doPrivileged(Native Method)

    at java.net.URLClassLoader.findClass(Unknown Source)

    at java.lang.ClassLoader.loadClass(Unknown Source)

    at java.lang.ClassLoader.loadClass(Unknown Source)

    at com.itko.lisa.jdbc.JDBCNode.getConnection(JDBCNode.java:613)

    at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:370)

    at com.itko.lisa.jdbc.JDBCNode.execute(JDBCNode.java:341)

    at com.itko.lisa.test.TestNode.executeNode(TestNode.java:981)

    at com.itko.lisa.test.TestCase.execute(TestCase.java:1280)

    at com.itko.lisa.test.TestCase.execute(TestCase.java:1195)

    at com.itko.lisa.test.TestCase.executeNextNode(TestCase.java:1180)

    at com.itko.lisa.test.TestCase.executeTest(TestCase.java:1124)

    at com.itko.lisa.coordinator.Instance.run(Instance.java:204)

     

    Any idea???

     

    Note: The same set of drivers were working for the same db on LISA7