Hibernate Nullpointerexception Due To Infinite Inward Hql Named Queries

If y'all are using Hibernate for implementing persistence layer inward Java as well as JEE application from pair of years as well as thus y'all would possess got seen this notorious NullPointerException while executing HQL named queries, Exception inward thread “main” java.lang.NullPointerException at org.hibernate.hql.ast.ParameterTranslationsImpl .getNamedParameterExpectedType (ParameterTranslationsImpl.java:63).  Hibernate has around pitiful logging inward instance of Exception, which has caused me hours to debug a uncomplicated problem. By looking at NullPointerException below (look sum stacktrace below), I had no clue that it's coming because of a missing infinite on HQL (Hibernate Query language) query. You tin every bit good accept a await if y'all tin figure this out :


Exception inward 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

If y'all are using Hibernate for implementing persistence layer inward Java as well as JEE application Hibernate NullPointerException due to Space inward HQL named queriesHQL query


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

After spending around fourth dimension I institute that it was happening due to an extra infinite given afterwards the colon inward the hibernate query (HQL). For illustration nosotros had this every bit query String

select EMP_ADDRESS from Employee where EMP_ID = :  ID

Do y'all divulge the extra space? Well it's non that slow to location this sort of error. Now all y'all demand to create to withdraw this NullPointerException is that to withdraw that extra white infinite from HQL query String i.e.

select EMP_ADDRESS from Employee where EMP_ID = : ID

So e'er position attending what y'all position betwixt colon as well as parameter inward named SQL queries. Of class Hibernate tin create amend project to render to a greater extent than information spell reporting fault instead of only throwing blank NullPointerException, which instead of giving around clue tin really good mislead y'all into dissimilar direction. This is the employment amongst whatever language, they tin non validate anything which is within String, wouldn't it endure amend if your HQL are every bit good larn validated at compile fourth dimension instead of runtime?

Further Learning
answer)
  • Difference betwixt get() as well as load() method inward Hibernate? (answer)
  • 5 Spring as well as Hibernate Training Courses for Java developers (list)
  • 2 Books to Learn Hibernate inward 2017 (books)
  • 5 Books to Learn Spring Framework inward 2017 (books)
  • Why Hibernate Entity class should non endure terminal inward Java? (answer)
  • 10 Hibernate Questions from Java Interviews (list)

    • Thanks for reading this article, if y'all similar this article as well as interview inquiry as well as thus delight percentage amongst your friends as well as colleagues. If y'all possess got whatever inquiry or feedback as well as thus delight drib a comment.

    Komentar

    Posting Komentar

    Postingan populer dari blog ini

    Difference Betwixt Struts Validatorform Vs Validatoractionform - Interview Question

    Gambar
    Struts render ii classes ValidatorForm as well as ValidatorActionForm for validating shape fields. Instead of doing basic validation past times using the validate() method inward Action class, these classes allows yous to leverage rich characteristic of validation framework provided past times Djakarta Struts framework. You tin exercise declarative validation past times defining rules inward XML config files similar validation-rule.xml or validations.xml every bit well. Since Struts is i of the pop Web MVC frameworks, yous tin likewise role its validation framework on whatever Java spider web application implemented using Struts. Now, coming dorsum to the question, what is the actual divergence betwixt ValidatorForm as well as ValidatorActionForm inward Struts? They both expect quite similar, right? Well, fifty-fifty though both ValidatorForm as well as ValidatorActionForm provides validation back upward as well as tin live on used to validate shape fields inward Struts application...
    Baca selengkapnya

    How To Convert Inputstream To Byte Array Inwards Coffee - Two Examples

    Sometimes nosotros quest to convert InputStream to byte array inwards Java, or y'all tin mail away order reading InputStream equally a byte array, In companionship to operate past times output to a method which accepts byte array rather than InputStream . One pop instance of this, I direct maintain seen is an older version of Apache common codec, whi le converting byte array to the hex string . Though, a afterward version of the same library do furnish a n overloaded method , to accept InputStream . Java File API provides first-class back upwardly to read files similar image, text equally InputStream inwards Java program, precisely equally I said, sometimes y'all quest String or byte array, instead of InputStream . Earlier nosotros direct maintain see n 5 ways to convert InputStream to String inwards Java , we tin mail away purpose roughly of the techniques from at that spot piece getting the yte array from InputStream inwards Java. If y'all similar to purpose Apach...
    Baca selengkapnya

    Difference Betwixt Fileinputstream Together With Filereader Inwards Coffee | Inputstream Vs Reader

    Gambar
    Before going to explicate specific deviation betwixt FileInputStream and FileReader in Java, I would similar to dry reason telephone substitution deviation betwixt an InputStream and a Reader in Java, in addition to when to purpose InputStream and when to choke for Reader . Actually, Both InputStream and Reader are abstractions to read information from source, which tin last either file or socket, just principal deviation betwixt them is, InputStream is used to read binary data, piece Reader is used to read text data, exactly Unicode characters. So what is deviation betwixt binary in addition to text data? good everything yous read is essentially bytes, just to convert a byte to text, yous ask a grapheme encoding scheme. Reader classes uses grapheme encoding to decode bytes in addition to render characters to caller. Reader can either purpose default grapheme encoding of platform on which your Java programme is running or convey a Charset object or mention of grapheme encoding inw...
    Baca selengkapnya