Native SQL query for a Hibernate entity using @Formula results in NullPointerException

Question

I've got an simple Hibernate entity for which I use the @Formula annotation:

@Id
private Long id;

private String name;

@Formula("(select count(f.*) from foo f where f.id = id)")
private long bar;

When I try to load an entity with a native SQL Query:

EM.createNativeQuery("SELECT f.*, count(something) as bar FROM foo f WHERE f.name = '...'", Entity.class)

I get an NullPointerException:

java.lang.NullPointerException
at org.hibernate.loader.DefaultEntityAliases.intern(DefaultEntityAliases.java:193)
at org.hibernate.loader.DefaultEntityAliases.getSuffixedPropertyAliases(DefaultEntityAliases.java:151)
at org.hibernate.loader.DefaultEntityAliases.determinePropertyAliases(DefaultEntityAliases.java:93)
at org.hibernate.loader.DefaultEntityAliases.<init>(DefaultEntityAliases.java:65)
at org.hibernate.loader.ColumnEntityAliases.<init>(ColumnEntityAliases.java:45)
at org.hibernate.loader.custom.sql.SQLQueryReturnProcessor.generateCustomReturns(SQLQueryReturnProcessor.java:197)
at org.hibernate.loader.custom.sql.SQLCustomQuery.<init>(SQLCustomQuery.java:152)
at org.hibernate.engine.query.NativeSQLQueryPlan.<init>(NativeSQLQueryPlan.java:67)
at org.hibernate.engine.query.QueryPlanCache.getNativeSQLQueryPlan(QueryPlanCache.java:140)
at org.hibernate.impl.AbstractSessionImpl.getNativeSQLQueryPlan(AbstractSessionImpl.java:160)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:179)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:236)

When I remove the @Formula attribute all works fine.

I found this bug report: BugReport. But for me it's not clear how to solve my problem.

scraymer · Accepted Answer · 2018-02-27 19:52:41Z

5

Indeed, this seems to be the problem reported in HHH-2225 (that HHH-2536 duplicates). Unfortunately, the issue is not fixed and I'm afraid you'll have to either use HQL or submit a patch (you can start with voting on the issue but I wouldn't expect a fast resolution given that this issue is almost four years old).

edited Feb 27, 2018 at 19:52

scraymer

4607 silver badges15 bronze badges

answered Jul 26, 2010 at 0:24

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jacob van Lingen Over a year ago

Years later, I still stumble upon this bug :(

ihebiheb Over a year ago

I have the same issue with Hibernate 5.4.3.Final

Andy · Accepted Answer · 2013-07-16 23:39:58Z

0

We could use currentSession.createQuery() instead of currentSession.createSQLQuery(). The query will be slightly different.

http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/queryhql.html#queryhql-subqueries

answered Jul 16, 2013 at 23:39

Andy

1,1431 gold badge9 silver badges19 bronze badges

Comments

Ibrahim Darwiesh · Accepted Answer · 2019-10-15 12:52:54Z

0

Simply way , don't use createNativeQuery , just use createQuery .. or make a transiant with getter convat

answered Oct 15, 2019 at 12:52

Ibrahim Darwiesh

75 bronze badges

1 Comment

DeshDeep Singh Over a year ago

Provide some examples please

Collectives™ on Stack Overflow

Native SQL query for a Hibernate entity using @Formula results in NullPointerException

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related