cassandra - "All host(s) tried for query failed" Error -

cassandra - "All host(s) tried for query failed" Error -

my java code follows:

import com.datastax.driver.core.cluster; import com.datastax.driver.core.metadata; import com.datastax.driver.core.session; public class customercontroller { public void execute() { cluster cluster = cluster.builder() .addcontactpoints("172.16.11.126", "172.16.11.130") .withport(9042) .build(); session session = cluster.connect(); string command = "drop keyspace if exists bookstore"; session.execute(command); cluster.close(); } }

when run code, next error:

exception in thread "main" com.datastax.driver.core.exceptions.nohostavailableexception: host(s) tried query failed (tried: /172.16.11.130 (com.datastax.driver.core.transportexception: [/172.16.11.130] cannot connect), /172.16.11.126 (com.datastax.driver.core.transportexception: [/172.16.11.126] cannot connect)) @ com.datastax.driver.core.controlconnection.reconnectinternal(controlconnection.java:195) @ com.datastax.driver.core.controlconnection.connect(controlconnection.java:78) @ com.datastax.driver.core.cluster$manager.init(cluster.java:1029) @ com.datastax.driver.core.cluster.init(cluster.java:120) @ com.datastax.driver.core.cluster.connect(cluster.java:197) @ com.pragatisoftware.datastax99.app.customercontroller.execute(customercontroller.java:12) @ com.pragatisoftware.datastax99.app.application.run(application.java:10) @ com.pragatisoftware.datastax99.app.application.main(application.java:6)

environment information:

ubuntu machine eclipse luna java 1.7 cassandra 2.0.11

in cassandra.yaml:

native_transport_port: 9042

cassandra running on both ip addresses provided above (172.16.11.130 , 172.16.11.126) , able connect using cqlsh both machines.

by way, same code (with appropriate ip address) worked on windows machine, using cassandra 2.0.9.

change rpc_address: 0.0.0.0 broadcast_rpc_address: 1.2.3.4 (should not 0.0.0.0) . cassandra version 2.1.10

also farther issue read cassandra.yaml file . lot of things self explanatory.

cassandra datastax-java-driver