Hibernate Nullpointerexception Due To Infinite Inward Hql Named Queries

If y'all are using Hibernate for implementing persistence layer inwards Java in addition to JEE application from yoke of years in addition to thence y'all would take keep seen this notorious NullPointerException while executing HQL named queries, Exception inwards thread “main” java.lang.NullPointerException at org.hibernate.hql.ast.ParameterTranslationsImpl .getNamedParameterExpectedType (ParameterTranslationsImpl.java:63).  Hibernate has simply about pitiful logging inwards representative of Exception, which has caused me hours to debug a uncomplicated problem. By looking at NullPointerException below (look amount stacktrace below), I had no clue that it's coming because of a missing infinite on HQL (Hibernate Query language) query. You tin besides accept a await if y'all tin figure this out :

Exception inwards thread “main” java.lang.NullPointerException at org.hibernate.hql.ast.ParameterTranslationsImpl.getNamedParameterExpectedType(ParameterTranslationsImpl.java:63) at org.hibernate.engine.query.HQLQueryPlan.buildParameterMetadata(HQLQueryPlan.java:296) at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:97) at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623

HQL query

public Type getNamedParameterExpectedType(String name) {     return getNamedParameterInfo( mention ).getExpectedType(); }

After spending simply about fourth dimension I institute that it was happening due to an extra infinite given later the colon inwards the hibernate query (HQL). For representative nosotros had this every bit query String

select EMP_ADDRESS from Employee where EMP_ID = :  ID

Do y'all bring out the extra space? Well it's non that slow to topographic point this form of error. Now all y'all demand to create to take away this NullPointerException is that to take away that extra white infinite from HQL query String i.e.

select EMP_ADDRESS from Employee where EMP_ID = : ID

So ever seat attending what y'all seat betwixt colon in addition to parameter inwards named SQL queries. Of course of pedagogy Hibernate tin create improve project to render to a greater extent than information piece reporting fault instead of simply throwing blank NullPointerException, which instead of giving simply about clue tin rattling good mislead y'all into dissimilar direction. This is the work amongst whatever language, they tin non validate anything which is within String, wouldn't it live on improve if your HQL are besides larn validated at compile fourth dimension instead of runtime?

Further Learning
answer)

Difference betwixt get() in addition to load() method inwards Hibernate? (answer)

5 Spring in addition to Hibernate Training Courses for Java developers (list)

2 Books to Learn Hibernate inwards 2017 (books)

5 Books to Learn Spring Framework inwards 2017 (books)

Why Hibernate Entity cast should non live on terminal inwards Java? (answer)

10 Hibernate Questions from Java Interviews (list)

Thanks for reading this article, if y'all similar this article in addition to interview inquiry in addition to thence delight percentage amongst your friends in addition to colleagues. If y'all take keep whatever inquiry or feedback in addition to thence delight drib a comment.

Share this post