Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

This issue can't be edited

Because it belongs to an archived project. Jira admins can restore projects from the archive.

[Neo4J] Using embedded object in JPQL and binding a named parameter causes an exception

Description

final Query jpqlQuery = em.createQuery("from UserProfile p where p.address.city = :city");
jpqlQuery.setParameter("city", "test");

Please find attached project to reproduce the issue.
Neo4JTest can be used as an entry point

Exception:
org.hibernate.MappingException: unknown property: city
at org.hibernate.persister.entity.AbstractPropertyMapping.getColumnNames(AbstractPropertyMapping.java:89)
at org.hibernate.persister.entity.AbstractEntityPersister.getPropertyColumnNames(AbstractEntityPersister.java:1982)
at org.hibernate.ogm.datastore.neo4j.query.parsing.impl.Neo4jPropertyHelper.getColumnName(Neo4jPropertyHelper.java:84)
at org.hibernate.ogm.datastore.neo4j.query.parsing.impl.Neo4jPropertyHelper.getColumnName(Neo4jPropertyHelper.java:75)
at org.hibernate.ogm.datastore.neo4j.query.parsing.impl.predicate.impl.Neo4jPredicateFactory.columnName(Neo4jPredicateFactory.java:109)
at org.hibernate.ogm.datastore.neo4j.query.parsing.impl.predicate.impl.Neo4jPredicateFactory.getComparisonPredicate(Neo4jPredicateFactory.java:49)
at org.hibernate.hql.ast.spi.SingleEntityQueryBuilder.addComparisonPredicate(SingleEntityQueryBuilder.java:87)
at org.hibernate.ogm.datastore.neo4j.query.parsing.impl.Neo4jQueryRendererDelegate.addComparisonPredicate(Neo4jQueryRendererDelegate.java:185)
at org.hibernate.ogm.datastore.neo4j.query.parsing.impl.Neo4jQueryRendererDelegate.predicateEquals(Neo4jQueryRendererDelegate.java:163)
at org.hibernate.hql.ast.render.QueryRenderer.predicate(QueryRenderer.java:5197)
at org.hibernate.hql.ast.render.QueryRenderer.searchCondition(QueryRenderer.java:4871)
at org.hibernate.hql.ast.render.QueryRenderer.whereClause(QueryRenderer.java:2347)
at org.hibernate.hql.ast.render.QueryRenderer.querySpec(QueryRenderer.java:2202)
at org.hibernate.hql.ast.render.QueryRenderer.queryExpression(QueryRenderer.java:2105)
at org.hibernate.hql.ast.render.QueryRenderer.queryStatement(QueryRenderer.java:1744)
at org.hibernate.hql.ast.render.QueryRenderer.queryStatementSet(QueryRenderer.java:1657)
at org.hibernate.hql.ast.render.QueryRenderer.statement(QueryRenderer.java:653)
at org.hibernate.hql.ast.spi.QueryRendererProcessor.process(QueryRendererProcessor.java:51)
at org.hibernate.hql.QueryParser.parseQuery(QueryParser.java:82)
at org.hibernate.ogm.datastore.neo4j.query.parsing.impl.Neo4jBasedQueryParserService.parseQuery(Neo4jBasedQueryParserService.java:40)
at org.hibernate.ogm.query.impl.OgmQueryTranslator.getLoader(OgmQueryTranslator.java:131)
at org.hibernate.ogm.query.impl.OgmQueryTranslator.doCompile(OgmQueryTranslator.java:120)
at org.hibernate.ogm.query.impl.LegacyParserBridgeQueryTranslator.compile(LegacyParserBridgeQueryTranslator.java:55)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1800)
at org.hibernate.engine.spi.SessionDelegatorBaseImpl.createQuery(SessionDelegatorBaseImpl.java:401)
at org.hibernate.ogm.jpa.impl.OgmEntityManager.createQuery(OgmEntityManager.java:209)
at by.defascathibernate.ogm.test.BasicTest.lambda$test5FindJPQL$0(BasicTest.java:67)
at by.defascathibernate.ogm.test.BasicTest$$Lambda$1/1168232535.accept(Unknown Source)
at by.defascathibernate.ogm.test.BasicTest.doInTransaction(BasicTest.java:49)
at by.defascathibernate.ogm.test.BasicTest.test5FindJPQL(BasicTest.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Environment

None

Attachments

1
  • 17 Feb 2015, 01:24 PM

Activity

Show:

Emmanuel Bernard February 19, 2015 at 4:43 PM

Duplicate of OGM-692.

Emmanuel Bernard February 19, 2015 at 4:42 PM

Davide D'Alto February 19, 2015 at 4:41 PM

It seems a bug, Neo4j should support param mapping.

I suspect it's the fact that it's referring an embedded property.

Emmanuel Bernard February 19, 2015 at 4:38 PM

is that "expected" because we don't support param mapping in Neo4J or is that a bug?

Duplicate

Details

Assignee

Reporter

Bug Testcase Reminder (view)

Bug reports should generally be accompanied by a test case!

Bug Testcase Reminder (edit)

Bug reports should generally be accompanied by a test case!

Participants

Andrey Panasyuk
Davide D'Alto
Emmanuel Bernard

Components

Fix versions

Affects versions

Priority

Created February 17, 2015 at 1:24 PM
Updated February 27, 2015 at 1:19 PM
Resolved February 19, 2015 at 4:43 PM
Configure