Hi Team,
When i add sort function to the existing query for MongoDB using hibernate ogm im getting java.lang.IllegalArgumentException, yet the same query is running fine in the mongo shell...
Iam using hibernateOGM 5.0.0.CR1...






the code is:



Thanks in advance

--Javed

Hi,

as stated in the documentation (http://docs.jboss.org/hibernate/ogm/5.0/reference/en-US/html/ch11.html#ogm-mongodb-queries-native):



So, your query should be:


You can set the limit using


That said, I'm trying the $regex operator and it does not seem to work at the moment.

Davide

Hi Team,
Iam still facing the same issue even though i changed to $orderby instead of $sort










Kindly give me a solution,

Thanks in advance.

--Javed

Hi,



This query is working fine in mongodb shell but throwing an exception when i access it through java hibernate ogm native query...



Thanks,
-Javed

.aggregate() is not supported at the moment.

I've created an issue to keep track of this: https://hibernate.atlassian.net/browse/OGM-1024

Davide

Okay..
When can we expect the full fledged working of hibernate ogm?
(or) if such functions like .sort() / .aggregate() doesnt work with nativeQueries, is there any other way to access them??

> When can we expect the full fledged working of hibernate OGM?

Good question, I don't have an answer to this.

I've tried to propose this issue to some contributors but nobody started working on it yet.
One of us might decide to tackle this issue but if you want to speed up the process
you can try to vote for it on the JIRA or propose a solution yourself, that would be much appreciated.

Hi, I have had the same problem :-/

My environment is:
WildFly 10
Hibernate OGM 5.0.1.final

If I use a simple query like:


Everything works. But if I try a little complex query :



It throws the following exception:

Any ideas on how to do an order by/sort? $orderby was deprecated in MongoDB in v3.2, and .sort() is not supported in Hibernate OGM 5.0.2.

Also, it's not quite clear to me why native queries don't just simply "work". I resorted to using a native query because of a limitation of JPA support (I think it was OGM-825). If any one can provide some literature on this I would appreciate it.

hi

currently the bug which was reported seem to be resolved in 5.x version. https://hibernate.atlassian.net/browse/OGM-1024

I was trying to perform an aggregate function for a native query.

db.user_interaction.aggregate([ {'$unwind':'$page_session'}, {'$unwind': '$page_session.click'}, {'$match' : {'page_session.click.resource_name':'campaign'}}, {'$group':{ '_id':'$page_session.click.resource_id', 'averageSessionDuration': {'$avg':'$page_session.timespent'}, 'viewerCount':{'$sum':1} }}])

I get the error

I am not sure if i am missing something here.

Caused by: org.bson.json.JsonParseException: JSON reader was expecting a value but found 'db'.
at org.bson.json.JsonReader.readBsonType(JsonReader.java:237) ~[mongo-java-driver-3.4.2.jar:?]
at com.mongodb.DBObjectCodec.readDocument(DBObjectCodec.java:345) ~[mongo-java-driver-3.4.2.jar:?]
at com.mongodb.DBObjectCodec.decode(DBObjectCodec.java:138) ~[mongo-java-driver-3.4.2.jar:?]
at com.mongodb.DBObjectCodec.decode(DBObjectCodec.java:61) ~[mongo-java-driver-3.4.2.jar:?]
at com.mongodb.BasicDBObject.parse(BasicDBObject.java:75) ~[mongo-java-driver-3.4.2.jar:?]
at com.mongodb.BasicDBObject.parse(BasicDBObject.java:62) ~[mongo-java-driver-3.4.2.jar:?]
at org.hibernate.ogm.datastore.mongodb.query.parsing.nativequery.impl.MongoDBQueryDescriptorBuilder.parse(MongoDBQueryDescriptorBuilder.java:99) ~[hibernate-ogm-mongodb-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.ogm.datastore.mongodb.query.parsing.nativequery.impl.MongoDBQueryDescriptorBuilder.build(MongoDBQueryDescriptorBuilder.java:78) ~[hibernate-ogm-mongodb-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.ogm.datastore.mongodb.MongoDBDialect.parseNativeQuery(MongoDBDialect.java:862) ~[hibernate-ogm-mongodb-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.ogm.datastore.mongodb.MongoDBDialect.parseNativeQuery(MongoDBDialect.java:143) ~[hibernate-ogm-mongodb-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.ogm.dialect.impl.ForwardingGridDialect.parseNativeQuery(ForwardingGridDialect.java:200) ~[hibernate-ogm-core-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.ogm.query.impl.NativeNoSqlQueryInterpreter.getCustomQuery(NativeNoSqlQueryInterpreter.java:50) ~[hibernate-ogm-core-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.ogm.query.impl.NativeNoSqlQueryInterpreter.createQueryPlan(NativeNoSqlQueryInterpreter.java:45) ~[hibernate-ogm-core-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.engine.query.spi.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:210) ~[hibernate-core-5.0.11.Final.jar:5.0.11.Final]
at org.hibernate.ogm.hibernatecore.impl.OgmSessionImpl.list(OgmSessionImpl.java:301) ~[hibernate-ogm-core-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.ogm.query.impl.NoSQLQueryImpl.list(NoSQLQueryImpl.java:130) ~[hibernate-ogm-core-5.0.4.Final.jar:5.0.4.Final]
at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]

It should be solved but we haven't released it yet.

Which version are you using?