question

Hi @chandrasekar.b03_190734,

from our discussion I understood that you are following this example with Java driver 4.6 or newer:

https://docs.datastax.com/en/astra/aws/doc/dscloud/astra/dscloudConnectJavaDriver.html

and you are getting timeout errors during the initial connection (I have removed all cluster ids and ip addresses from this error message):

Exception in thread "main" com.datastax.oss.driver.api.core.AllNodesFailedException: Could not reach any contact point, make sure you've provided valid addresses (showing first 1 nodes, use getAllErrors() for more): Node(endPoint=xxxxxxxxxxxxxxxxxxxxxxxxx-europe-west1.db.astra.datastax.com:31098:xxxxxxxxxxxxxxxxxxxxxxx, hostId=null, hashCode=4f515049): [com.datastax.oss.driver.api.core.DriverTimeoutException: [s0|control|id: 0x6c6b084d, L:/xxx.xxx.xxx.xxx:54083 - R:xxxxxxxxxxxxxxxxxxxxxxxxx-europe-west1.db.astra.datastax.com/xxx.xxx.xxx.xxx:31098] Protocol initialization request, step 1 (OPTIONS): timed out after 500 ms]
.

As you can see, the connection times out after 500ms, and we have seen a few instances where this is too aggressive, also for connections from Europe to Astra Europe West1.

The recommendation is to increase the timeouts.

You can do this by setting advanced options in. the application.conf, which is the recommended way to configure the driver.

To read up about the application.conf, please see this documentation:

https://docs.datastax.com/en/developer/java-driver/4.7/manual/core/configuration/

To get you going for a simple test, make the following changes to your project.

Add an application.conf file in the classpath (or an absolute path, or an URL). It only needs to contain the options that you override. For example, in my IntelliJ project, I create the file application.conf in the resources folder of the project.

Set the following options in the application.conf:

datastax-java-driver {

  advanced.connection {
    connect-timeout = 10 second
    init-query-timeout = 10 seconds
    set-keyspace-timeout = 10 seconds

  }

  advanced.control-connection {
    timeout = 10 seconds
  }
}

The driver ships with a reference.conf (you can find it in the driver package for inspection), where you can read more about these settings.

Let us know if this enables you to establish a successful connection.