Forum Discussion

kamleshwaghela0's avatar
kamleshwaghela0
11 years ago

Apache Cassandra CQL - jdbc connection

Hi, Could you please advise, whether SoapUI support Apache Cassandra jdbc connection strings. If it does then could you please confirm whether I have used correct information. Driver: org.apa...
shuiyiting's avatar
shuiyiting
New Contributor
8 years ago

jdbc connection by thrift are disable in cassandra, to resolve that i tried connect by dse-driver, here are my steps:

 

  1. copy these jars into soapui bin/ext:

    dse-java-driver-core-1.4.0

    dse-java-driver-mapping-1.4.0

    metrics-core-3.0.2

    netty-all-4.1.6.Final

  2. update guava jar in lib:

    guava-18.0

  3. launch soapui and create groovy script:

 

import com.datastax.driver.core.*;

Cluster cluster = null;

cluster = new Cluster.Builder().addContactPoints("127.0.0.1").withPort(9042).build();
    
Session session = cluster.connect();                         
PreparedStatement statement = session.prepare("select * from keyspace.exemple_table");

ResultSet rs = session.execute(statement.bind());
Row row = rs.one();