Skip to content
This repository has been archived by the owner on Dec 30, 2020. It is now read-only.

Connection to cassandra failing using cassandra-jdbc-wrapper #20

Open
Anu001 opened this issue Oct 12, 2017 · 0 comments
Open

Connection to cassandra failing using cassandra-jdbc-wrapper #20

Anu001 opened this issue Oct 12, 2017 · 0 comments

Comments

@Anu001
Copy link

Anu001 commented Oct 12, 2017

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant