I pull the image for Cassandra and run a container and create the database, I want to add its data source on DataGrip to manage the database from there. When I run the container I made it listen to the ports. I am using localhost and I try to access the database with jdbc:cassandra://localhost:9842 URL.
I tried to connect, but every time I get the error:
All host(s) tried for query failed (tried: localhost/127.0.0.1:9842 (com.datastax.driver.core.exceptions.TransportException: [localhost/127.0.0.1:9842] Channel has been closed)).
Please help me to fix. Any help would be appreciated.