spring-data-jpa - java.lang.IllegalArgumentException：不支持的关键字：GREATER_THAN_EQUAL (1): [IsGreaterThanEqual, GreaterThanEqual]

Question

我在 Azure cosmos DB 上使用 Spring JPA。

我的代码在这里

public interface DeviceTelemetryRepository extends DocumentDbRepository<DeviceTelemetry, String>{

    List<DeviceTelemetry> findAll();

    @Query(value="SELECT * FROM DeviceTelemetry where deviceId= ?1 and date >= ?2 and date <= ?3", nativeQuery = true)
    List<DeviceTelemetry> findDeviceTelemetryByDeviceIdAndDateGreaterThanEqualAndDateLessThanEqual(@Param("deviceId") int deviceId,
                                                               @Param("from") long from,
                                                               @Param("to") long to    );

}

错误信息：

java.lang.IllegalArgumentException：不支持的关键字：GREATER_THAN_EQUAL (1): [IsGreaterThanEqual, GreaterThanEqual] at com.microsoft.azure.spring.data.documentdb.repository.query.DocumentDbQueryCreator.from(DocumentDbQueryCreator.java:82) ~[spring- data-cosmosdb-2.0.3.jar:na] 在 com.microsoft.azure.spring.data.documentdb.repository.query.DocumentDbQueryCreator.and(DocumentDbQueryCreator.java:56) ~[spring-data-cosmosdb-2.0.3 .jar:na] at com.microsoft.azure.spring.data.documentdb.repository.query.DocumentDbQueryCreator.and(DocumentDbQueryCreator.java:25) ~[spring-data-cosmosdb-2.0.3.jar:na] at org .springframework.data.repository.query.parser.AbstractQueryCreator.createCriteria(AbstractQueryCreator.java:122) ~[spring-data-commons-2.0.10.RELEASE.jar:2.0.10.RELEASE] at org.springframework.data。存储库.查询.解析器。AbstractQueryCreator.createQuery(AbstractQueryCreator.java:95) ~[spring-data-commons-2.0.10.RELEASE.jar:2.0.10.RELEASE] at org.springframework.data.repository.query.parser.AbstractQueryCreator.createQuery(AbstractQueryCreator .java:81) ~[spring-data-commons-2.0.10.RELEASE.jar:2.0.10.RELEASE]

你有什么经验吗？谢谢！

标签： spring-data-jpaazure-cosmosdb

Answer 1

我找到了 spring-data-cosmos db 的解决方案。我从 Microsoft Github 得到了答复。

https://github.com/Microsoft/spring-data-cosmosdb/issues/347

azure-documentdb-spring-boot-starter 是旧版本。