Agree with Shiney . You would need to download cassandra_driver and place them in Devtest.
Driver: cassandra_driver.jar
To execute as devtest’s JDBC connection use following parameter values. Use other parameter info as appropriate. Once jar is placed in devtest/Lib folder, restart /devtest.
JDBC Driver: org.apache.cassandra.cql.jdbc.CassandraDriver
Connection String: jdbc:cassandra://host:port/keyspace
One way you can connect to Cassandra using Devtest– Execute Script ( JSR-223) step . Also you can directly connect using JDBC step as well.
//Import
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
Connection con = null;
try {
//Classname
Class.forName("org.apache.cassandra.cql.jdbc.CassandraDriver");
//from Input parameters.
//String node = testExec.getStateValue("host");
//String port = testExec.getStateValue("port");
//String keyspace = testExec.getStateValue("keyspace");
//String query = testExec.getStateValue("query");
//Build connection string
String connectionString = "jdbc:cassandra://" + node + ":" + port + "/" + keyspace;
//Database calls code
write code for conn and execute query.
}
Hope this helps.
Thanks,
Rajeh k Singh