I am connection to a Cassandra database with Java using the "BasicDataSource" class in the Apache Common DBCP library and using the DataStax driver "com.simba.cassandra.jdbc42.Driver". When Cassandra is configured with the "authenticator" set to "AllowAllAuthenticator", I can connection to the database. However when I enable "PasswordAuthenticator" and set the username/password in the "BasicDataSource" object, I cannot connect and get the exception "Authentication error on host /IP Address:Port: Host /IP Address:Port requires authentication, but no authenticator found in Cluster configuration.". What is needed to establish a secure connection ?
Connecting to Cassandra using Java DBCP
419 Views Asked by lgriffin At
1
There are 1 best solutions below
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in CASSANDRA
- how to create a chess board with Queen in the central position and all its moves in assembler code
- Passing arguments to ENTRYPOINT causes the container to start and run indefinitely
- Apache Cassandra Node Driver Connection
- Simulate Cassandra DB timeout
- How to update Cassandra Lucene index with a new column? rebuild or update index?
- Cassandra JDBC connection string for logstash
- Cassandra OversizedMessageException
- dsbulk unload is failing after ran couple of hours with OOM issue
- Cassandra: "Model keyspace not set" and "Connection name doesn't exist in the registry" Errors
- Unable to cqlsh to a cassandra docker container remotely
- Forward pagination with object mapper in java asyn
- Allow filter in cassandra query
- How to fix bytes unrepaired in cassandra
- Can't install Cassandra using RPM packages for RHEL 9
- Why can't get a connection to Cassandra running on Docker from a Spring Boot instace using spring-boot-starter-data-cassandra on first boot?
Related Questions in DBCP
- Cannot get a connection, pool error Timeout waiting for idle object while using DBPC2
- DBCP connection property name issue
- How should I connect my web app in java with the database? With jdbc coming from a jar file in referenced libraries or dbcp?
- SQL Server returned an incomplete response. The connection has been closed.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException:
- BasicDataSource Support domain name？
- how to reload password in dbcp basic datasource
- Java BasicDataSource getting stuck when connecting
- Connecting to Cassandra using Java DBCP
- Java and MariaDB connection drivers errors
- java connection pool and autocommit status
- Concurrency logging to sql DB - threads not running parallel
- Getting error on shutdown of simple Micronaut CLI data application
- setting connectionTimedOut to 1 sec is throwing Socket Timed Out error
- java dbcp2 multithreaded connection access
- Apache felix cannot load dbcp2 as bundle
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I have answered my own question. For anyone with the same problem, the solution is to include the option "AuthMech=1" in the JDBC connection string as it is needed for authenticated connections. The following is from the "Simba Cassandra JDBC Driver with SQL Connector" installation and configuration guide:
"AuthMech
This property specifies whether the driver connects to a Cassandra or Astra database, and whether the driver authenticates the connection.
Ref: https://docs.datastax.com/en/driver-matrix/doc/latestSimbaCassJDBCDriver.html (Page 31)