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...
Forum Discussion
Hi,
I have seen that connection string format but you should make sure you have all you need in it or whether some credentials are also necessary. I suggest you create a connection string template in SoapUI Preferences (from File menu), on the JDBC Drivers Properties tab for your database. Add an entry for your database: Ex: jdbc:cassandra://<HOST:127.0.0.1>:<PORT:50000>/<DB>
That way you can configure the JDBC TestStep using the Configure button when you select your database.
Having the driver placed in the \bin\ext folder, that setup should work.
Regards,
Giscard
SmartBear Support
I have seen that connection string format but you should make sure you have all you need in it or whether some credentials are also necessary. I suggest you create a connection string template in SoapUI Preferences (from File menu), on the JDBC Drivers Properties tab for your database. Add an entry for your database: Ex: jdbc:cassandra://<HOST:127.0.0.1>:<PORT:50000>/<DB>
That way you can configure the JDBC TestStep using the Configure button when you select your database.
Having the driver placed in the \bin\ext folder, that setup should work.
Regards,
Giscard
SmartBear Support
I trying to connect to Cassandra database, I have all the dependencies in the bin/ext folder for ready api. When connecting to the cassandra, I getting the following error " Can't get the Connection for specified properties; java.sql.SQLNonTransientConnectionException: Keyspace names must be composed of alphanumerics and underscores (parsed: 'cassandra@localhost:9042/demo23_123') " even though i have keyspace name as suggested.
I did try to connect with groovy script as well. Did get the same error
here is the code for grovvy script
import java.sql.DriverManager;
import java.sql.SQLFeatureNotSupportedException;
import java.sql.Statement;
import javax.sql.DataSource;
import org.apache.cassandra.cql.jdbc.*;
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("org.apache.cassandra.cql.jdbc.CassandraDriver");
def con = DriverManager.getConnection("jdbc:cassandra://cassandra/cassandra@localhost:9042/demo23_123"); //keyspace has to be in lowercase
def stmt = con.createStatement();
//add data
def qry = "select * from patient"
def rs = stmt.executeUpdate(qry);
Request to suggest to continue this R&D activity.
Thanks
Raghu Raghavan
Hi Raghu,
Were you able to connect to cassandra using SOAP UI?
