When trying to connect to Cassandra through SoapUI using com.github.adejanovski.cassandra.jdbc.CassandraDriver I am unable to send the credentials for the Cassandra server. Could you please share the format for the connection string with credentials.
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("com.github.adejanovski.cassandra.jdbc.CassandraDriver");
def con = DriverManager.getConnection("jdbc:cassandra://172.17.80.171:9042/transactionhistorylookup");
def stmt = con.createStatement();
Error message
java.sql.SQLNonTransientConnectionException: com.datastax.driver.core.exceptions.AuthenticationException: Authentication error on host /172.17.80.171:9042: Host /172.17.80.171:9042 requires authentication, but no authenticator found in Cluster configuration error at line: 7
2) With Credentials
When I try to pass the credentials in the Connection string as below, I get the following error.
def con = DriverManager.getConnection("jdbc:cassandra:cassandra/cassandra//172.17.80.171:9042/transactionhistorylookup","cassandra","cassandra");
Error Message - java.sql.SQLNonTransientConnectionException: Connection url must specify a host, e.g., jdbc:cassandra://localhost:9042/Keyspace1 error at line: 8
Cassandra Version - [cqlsh 5.0.1 | Cassandra 3.0.12.1586 | DSE 5.0.7 | CQL spec 3.4.0 | Native protocol v4] Soap UI Version - 5.2.1/5.3
When trying to connect to Cassandra through SoapUI using com.github.adejanovski.cassandra.jdbc.CassandraDriver I am unable to send the credentials for the Cassandra server. Could you please share the format for the connection string with credentials.
I am using the below groovy script.
1) With No Credentials
import java.sql.DriverManager; import com.github.adejanovski.cassandra.jdbc.CassandraDriver;
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("com.github.adejanovski.cassandra.jdbc.CassandraDriver"); def con = DriverManager.getConnection("jdbc:cassandra://172.17.80.171:9042/transactionhistorylookup"); def stmt = con.createStatement();
Error message java.sql.SQLNonTransientConnectionException: com.datastax.driver.core.exceptions.AuthenticationException: Authentication error on host /172.17.80.171:9042: Host /172.17.80.171:9042 requires authentication, but no authenticator found in Cluster configuration error at line: 7
2) With Credentials When I try to pass the credentials in the Connection string as below, I get the following error. def con = DriverManager.getConnection("jdbc:cassandra:cassandra/cassandra//172.17.80.171:9042/transactionhistorylookup","cassandra","cassandra");
Error Message - java.sql.SQLNonTransientConnectionException: Connection url must specify a host, e.g., jdbc:cassandra://localhost:9042/Keyspace1 error at line: 8