带有$ gt $ gte $ lt $ lte的Mongodb Count查询的Hibernate OGM不能与小于1一起使用 [英] Hibernate OGM With Mongodb Count query with $gt $gte $lt $lte not working with less than 1

问题描述

我在Mongodb(3.4)中使用Hibernate OGM(5.2.0.Alpha1)

I am using Hibernate OGM (5.2.0.Alpha1) with Mongodb (3.4)

我通过Hibernate OGM通过以下两种方式执行了Mongodb计数查询

I executed Mongodb Count Query Using Hibernate OGM by 2 below way

(1).使用Mongodb计数查询db.tablename.count({..})

(1). Count query using Mongodb count query db.tablename.count({..})

(2).通过Mongodb汇总查询计数查询...

(2). Count query by Mongodb Aggregate query...

说明

(1).使用Mongodb计数查询db.tablename.count({..})

(1). Count query using Mongodb count query db.tablename.count({..})

public long executeCountQuery(){

    //below line Works fine because value is 1.3 with $lt
    //String query= "db.sales_stone_details.count({'$and':[{'size' : { '$lt' : 1.3}}]})" 

    //below line gots Error because value is 0.3(less than 1) with $lt
    String query= "db.sales_stone_details.count({'$and':[{'size' : { '$lt' : 0.3}}]})"   

    long count = entityManager.createNativeQuery(query.toString()).getSingleResult();
    return count;
}

(2).通过Mongodb汇总查询计数查询...

(2). Count query by Mongodb Aggregate query...

public long executeCountQuery(){

    //below line Works fine because value is 1.3 with $lt
    //String query= "db.sales_stone_details.aggregate([{'$match': {'size': {'$lt': 1.3}}},{'$group': {'_id' :  ObjectId(\"59df0d28f16b004af040c38c\"), 'countForAggregate' : {'$sum' : 1}}}])"

    //below line gots Error because value is 0.3(less than 1) with $lt
    String query= "db.sales_stone_details.aggregate([{'$match': {'size': {'$lt': 0.3}}},{'$group': {'_id' :  ObjectId(\"59df0d28f16b004af040c38c\"), 'countForAggregate' : {'$sum' : 1}}}])"

    List<Stone> stones = entityManager.createNativeQuery(query.toString() , Stone.class).getResultList();

    long count = 0;
    if (stones != null || !stones.isEmpty()){
         count  = stones.get(0).getCountForAggregate();
    }

    return count;
}

错误

org.bson.json.JsonParseException: JSON reader was expecting a value but found 'db'.
    at org.bson.json.JsonReader.readBsonType(JsonReader.java:243) ~[mongo-java-driver-3.6.0-beta2.jar:na]
    at org.bson.codecs.DocumentCodec.decode(DocumentCodec.java:149) ~[mongo-java-driver-3.6.0-beta2.jar:na]
    at org.bson.codecs.DocumentCodec.decode(DocumentCodec.java:45) ~[mongo-java-driver-3.6.0-beta2.jar:na]
    at org.bson.Document.parse(Document.java:105) ~[mongo-java-driver-3.6.0-beta2.jar:na]
    at org.bson.Document.parse(Document.java:90) ~[mongo-java-driver-3.6.0-beta2.jar:na]
    at org.hibernate.ogm.datastore.mongodb.query.parsing.nativequery.impl.MongoDBQueryDescriptorBuilder.parseAsObject(MongoDBQueryDescriptorBuilder.java:252) ~[hibernate-ogm-mongodb-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.datastore.mongodb.query.parsing.nativequery.impl.MongoDBQueryDescriptorBuilder.parse(MongoDBQueryDescriptorBuilder.java:239) ~[hibernate-ogm-mongodb-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.datastore.mongodb.query.parsing.nativequery.impl.MongoDBQueryDescriptorBuilder.build(MongoDBQueryDescriptorBuilder.java:211) ~[hibernate-ogm-mongodb-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.datastore.mongodb.MongoDBDialect.parseNativeQuery(MongoDBDialect.java:892) ~[hibernate-ogm-mongodb-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.datastore.mongodb.MongoDBDialect.parseNativeQuery(MongoDBDialect.java:169) ~[hibernate-ogm-mongodb-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.dialect.impl.ForwardingGridDialect.parseNativeQuery(ForwardingGridDialect.java:212) ~[hibernate-ogm-core-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.query.impl.NativeNoSqlQueryInterpreter.getCustomQuery(NativeNoSqlQueryInterpreter.java:50) ~[hibernate-ogm-core-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.query.impl.NativeNoSqlQueryInterpreter.createQueryPlan(NativeNoSqlQueryInterpreter.java:45) ~[hibernate-ogm-core-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.engine.query.spi.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:210) ~[hibernate-core-5.1.10.Final.jar:5.1.10.Final]
    at org.hibernate.ogm.hibernatecore.impl.OgmSessionImpl.list(OgmSessionImpl.java:301) ~[hibernate-ogm-core-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.ogm.query.impl.NoSQLQueryImpl.list(NoSQLQueryImpl.java:130) ~[hibernate-ogm-core-5.2.0.Alpha1.jar:5.2.0.Alpha1]
    at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606) ~[hibernate-entitymanager-5.1.10.Final.jar:5.1.10.Final]
    at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529) ~[hibernate-entitymanager-5.1.10.Final.jar:5.1.10.Final]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_151]
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_151]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_151]
    at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_151]
    at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:372) ~[spring-orm-4.3.4.RELEASE.jar:4.3.4.RELEASE]
    at com.sun.proxy.$Proxy7512.getSingleResult(Unknown Source) ~[na:na]
    at com.techhive.sales.service.impl.GenericModelDaoImpl.executeCountQuery(GenericModelDaoImpl.java:621) ~[classes/:na]
...............
...........

我在$gt , $lte , $gte运算符上也遇到了相同的错误.

I got same error with $gt , $lte , $gte operators also.

但是$gt , $gte , $lt , $lte似乎不能使用小于1的值.

But it seems like $gt , $gte , $lt , $lte is not working with less than 1 value..

我说得对吗?

推荐答案

更新11/01/2018 :此问题应在下一发行版5.2中解决

UPDATE 11/01/2018: This issue should be fixed in the next release: 5.2

是的，您是对的.您发现了一个错误.我已经为此创建了一个问题，应该在下一个版本中对其进行修复: https://hibernate.atlassian.net/browse/OGM-1371

Yes, you are right. You found a bug. I've created an issue for it and it should be fixed in the next release: https://hibernate.atlassian.net/browse/OGM-1371

这篇关于带有$ gt $ gte $ lt $ lte的Mongodb Count查询的Hibernate OGM不能与小于1一起使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！