azure-samples / azure-spring-data-cosmos-java-sql-api-samples Goto Github PK

View Code? Open in Web Editor NEW

12.0 36.0 7.0 45 KB

Spring Data Azure Cosmos DB samples repo

License: MIT License

Java 100.00%

azure-spring-data-cosmos-java-sql-api-samples's People

Stargazers

Watchers

Forkers

amolbhole theovankraay rahulazurepoc maqakh trande4884 jiezhang0614 dino69

azure-spring-data-cosmos-java-sql-api-samples's Issues

Found typo: Should be "SELECT" instead of "ELECT" ;)

azure-spring-data-cosmos-java-sql-api-samples/src/main/java/com/azure/cosmos/springexamples/quickstart/sync/UserRepository.java

Lines 44 to 46 in 456b1fb

    
           // Query using range operators against strings 
        
           @Query(value = "ELECT * FROM Families f WHERE f.Address.State > 'NY'") 
        
           List<User> getUsersWithRangeAgainstStrings();

Can you please check if the count query is working fine. for me they are not returning the result as the return type is not proper

Please provide us with the following information:

This issue is for a: (mark with an `x`)

- [ ] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)

Versions

Mention any other details that might be useful

Thanks! We'll be in touch soon.

com.azure.cosmos.CosmosException: Message: {"Errors":["Resource Not Found. Learn more: https:\/\/aka.ms\/cosmosdb-tsg-not-found"]}

In SampleApplication.java

If I call function userRepository.getAllUsers(); , it will throw exception

error={"code":"NotFound","message":"Message: {\"Errors\":[\"Resource Not Found.   
Learn more: https:\\/\\/aka.ms\\/cosmosdb-\ tsg-not-found\"]}\r\nActivityId: e6e35cce-83ab-4e31-9674-566ac21e7312,  
Request URI: /apps/f56ce9b0-69fe-4151-840a-8e49704c36a4/services/e685e429-72e0-4744-9004-99dc6f2c3958/partitions/1c7e072b-9006-4e05-a884-297e20b1f334/replicas/132674189604669278s,   
RequestStats: \r\nRequestStartTime: 2021-06-07T07:45:34.3852316Z, RequestEndTime: 2021-06-07T07:45:34.3852316Z,    
Number of regions attempted:1\r\nResponseTime: 2021-06-07T07:45:34.3852316Z, StoreResult: StorePhysicalAddress:    
 rntbd://10.0.0.139:11300/apps/f56ce9b0-69fe-4151-840a-8e49704c36a4/services/e685e429-72e0-4744-9004-99dc6f2c3958/partitions/1c7e072b-9006-4e05-a884-297e20b1f334/replicas/132674189604669278s, LSN: 9,    
 GlobalCommittedLsn: 9, PartitionKeyRangeId: , IsValid: True, StatusCode: 404, SubStatusCode: 0, RequestCharge: 1, ItemLSN: -1, SessionToken: -1#9, UsingLocalLSN: False, TransportException: null, BELatencyMs: 0.347, ActivityId: e6e35cce-83ab-4e31-9674-566ac21e7312, ResourceType: Collection, OperationType: Read\r\nResponseTime: 2021-06-07T07:45:34.3852316Z,   
StoreResult:  StorePhysicalAddress: rntbd://10.0.0.25:11000/apps/f56ce9b0-69fe-4151-840a-8e49704c36a4/services/e685e429-72e0-4744-9004-99dc6f2c3958/partitions/1c7e072b-9006-4e05-a884-297e20b1f334/replicas/132674189604669279s, LSN: 9, GlobalCommittedLsn: 9, PartitionKeyRangeId: , IsValid: True, StatusCode: 404, SubStatusCode: 0, RequestCharge: 1, ItemLSN: -1, SessionToken: -1#9, UsingLocalLSN: False, TransportException: null, BELatencyMs: 0.345, ActivityId: e6e35cce-83ab-4e31-9674-566ac21e7312, ResourceType: Collection, OperationType: Read\r\n, SDK: Microsoft.Azure.Documents.Common/2.14.0, StatusCode: NotFound","additionalErrorInfo":null}, resourceAddress='null', requestUri='null', statusCode=404, message=Message: {"Errors":["Resource Not Found. Learn more: https:\/\/aka.ms\/cosmosdb-tsg-not-found"]}

This code cannot work with serverless plan!

Please provide us with the following information:

This issue is for a: (mark with an `x`)

- [x] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

This code cannot run with serverless plan CosmosDB, because it doesn't support Provisioned Troughput

Any log messages given by the failure

"Setting offer throughput or autopilot on container is not supported for serverless accounts.\r\nActivityId: ****, Microsoft.Azure.Documents.Common/2.14.0, StatusCode: BadRequest"

Mention any other details that might be useful

It works fine if you modify User.java at line 8,
Original:
@container(containerName = "myContainer", ru = "400")
Modified:
@container(containerName = "myContainer")

This repository linked from QuickStart MS document and most user may use serverless plan for evaluation. So please correct it ASAP! (Write some guidance in README or update the code.)

Thanks! We'll be in touch soon.

Can you please check if the count query is working fine. for me they are not returning the result as the return type is not proper.SELECT VALUE COUNT(1) FROM tableName c WHERE ( c.uploadDate BETWEEN @fromDate AND @toDate ) this is not working

Please provide us with the following information:

This issue is for a: (mark with an `x`)

- [ ] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)

Versions

Mention any other details that might be useful

Thanks! We'll be in touch soon.

	// Query using range operators against strings
	@Query(value = "ELECT * FROM Families f WHERE f.Address.State > 'NY'")
	List<User> getUsersWithRangeAgainstStrings();

azure-samples / azure-spring-data-cosmos-java-sql-api-samples Goto Github PK

azure-spring-data-cosmos-java-sql-api-samples's People

Stargazers

Watchers

Forkers

azure-spring-data-cosmos-java-sql-api-samples's Issues

Please provide us with the following information:

This issue is for a: (mark with an x)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Versions

Mention any other details that might be useful

Please provide us with the following information:

This issue is for a: (mark with an x)

Minimal steps to reproduce

Any log messages given by the failure

Mention any other details that might be useful

Please provide us with the following information:

This issue is for a: (mark with an x)

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Versions

Mention any other details that might be useful

Recommend Projects

Recommend Topics

Recommend Org

This issue is for a: (mark with an `x`)

This issue is for a: (mark with an `x`)

This issue is for a: (mark with an `x`)