I have a Client App (Striim) that I am using to connect to CockroachDB Cloud using JDBC. It failed - I then tried with DBeaver - that is also giving the same error.
I am able to connect using the cockroach shell.
The error message is
Failure in connecting to Database with url : jdbc:postgresql://free-tier.gcp-us-central1.cockroachlabs.cloud:26257/defaultdb?sslmode=verify-full&sslrootcert=/Users/sainatarajan/STRIIM_APPLICATIONS/COCKROACHDB/cc-ca.cer&options=–cluster=bubbly-mule username : sai ErrorCode : 0;SQLCode : 08004;SQL Message : FATAL: CodeParamsRoutingFailed: rejected by BackendConfigFromParams: Invalid cluster name
When using cockroach sell, the cluster name has a number added to it – whereas in the GUI, the name of the cluster is without the number - I tried both.