Cosmos db connect with java code --->>> How to ??

Ey 1

I am trying to connect to cosmos db with java code (Uisng intellij)
in order to validate some field exist or not.

can someone gove me the simplest sample code for doing connection and quick sql query for pull some data ?

Thanks!

1 answer

Oury Ba-MSFT 19,726 Reputation points Microsoft Employee

2021-08-13T06:19:49.85+00:00

Hi @Ey Thank you for posting your question.

Please try the below samples using either an IDE (Eclipse, IntelliJ, or VSCODE) or from the command line using Maven.

These environment variables must be set
ACCOUNT_HOST=your account hostname;ACCOUNT_KEY=your account primary key (https://learn.microsoft.com/en-us/azure/cosmos-db/sql-api-java-sdk-samples)

/ Create sync client
// <CreateSyncClient>
client = new CosmosClientBuilder()
.endpoint(AccountSettings.HOST)
.key(AccountSettings.MASTER_KEY)
.preferredRegions(preferredRegions)
.consistencyLevel(ConsistencyLevel.EVENTUAL)
.contentResponseOnWriteEnabled(true)
.buildClient();

Please refer to the below link for java Quickstart examples.

https://github.com/Azure-Samples/azure-cosmos-java-sql-api-samples/blob/main/src/main/java/com/azure/cosmos/examples/crudquickstart/sync/SampleCRUDQuickstart.java

Regards,
Oury
Please sign in to rate this answer.
Ey 1 Reputation point

2021-08-13T14:25:49.707+00:00

Got:
java.lang.RuntimeException: Client initialization failed. Check if the endpoint is reachable and if your auth token is valid

at com.azure.cosmos.implementation.RxDocumentClientImpl.initializeGatewayConfigurationReader(RxDocumentClientImpl.java:372) at com.azure.cosmos.implementation.RxDocumentClientImpl.init(RxDocumentClientImpl.java:393) at com.azure.cosmos.implementation.AsyncDocumentClient$Builder.build(AsyncDocumentClient.java:225) at com.azure.cosmos.CosmosAsyncClient.<init>(CosmosAsyncClient.java:104) at com.azure.cosmos.CosmosClientBuilder.buildAsyncClient(CosmosClientBuilder.java:729) at com.azure.cosmos.CosmosClient.<init>(CosmosClient.java:30) at com.azure.cosmos.CosmosClientBuilder.buildClient(CosmosClientBuilder.java:741) at CosmosDb.queriesDemo(CosmosDb.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)

Oury Ba-MSFT 19,726 Reputation points Microsoft Employee

2021-08-16T23:24:33.957+00:00

Hi @Ey Can you please make sure you are passing the correct credentials and check if your cosmosdb account is reachable. The cluster may have a firewall issue which can block the connection to the cosmos endpoint.

Regards,
Oury

Oury Ba-MSFT 19,726 Reputation points Microsoft Employee

2021-08-19T22:47:11.217+00:00

Hi @Ey Checking if you are still facing the same issue.?

Regards,
Oury

Oury Ba-MSFT 19,726 Reputation points Microsoft Employee

2021-08-23T23:15:03.007+00:00

Hi @Ey Haven't heard back from you. Checking on the status of the above issue .?

Regards,
Oury
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Cosmos db connect with java code --->>> How to ??

1 answer

Your answer