Search code examples
javajpqlopenjpa

JPQL Statement Invalid unbound variable "serial_number" in query

How can i make this work? I want to count serial number with a value of 1? Thanks guys i am a beginner.

serial_Number = 1;


Query query = (Query) es.em.createQuery("SELECT COUNT(p.serial_Number) FROM Product p where p.product_Id = serials_Number");
Solution

  • The following should work 

       Query query = (Query) es.em.createQuery("SELECT COUNT(p.serial_Number) FROM Product p where p.product_Id =:serial_Number").setParameter("serial_Number", serial_Number);

    Then use..

    query.getSingleResult();

    to get the singular entity.