Native query with named parameter fails with “Not all named parameters have been set”

by

Named parameters are not supported by JPA in native queries, only for JPQL. You must use positional parameters.

Named parameters follow the rules for identifiers defined in Section 4.4.1. The use of named parameters applies to the Java Persistence query language, and is not defined for native queries. Only positional parameter binding may be portably used for native queries.

So, use this

Query q = em.createNativeQuery("SELECT count(*) FROM mytable where username = ?1");
q.setParameter(1, "test");

While JPA specification doesn’t support named parameters in native queries, some JPA implementations (like Hibernate) may support it

Native SQL queries support positional as well as named parameters

However, this couples your application to specific JPA implementation, and thus makes it unportable.

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. How can I make a JPA OneToOne relation lazy
  3. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  4. How to map calculated properties with JPA and Hibernate
  5. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  6. Can someone explain mappedBy in JPA and Hibernate?
  7. When and why JPA entities should implement the Serializable interface?
  8. How to use @Id with String Type in JPA / Hibernate?
  9. JPA Hibernate One-to-One relationship
  10. I found JPA, or alike, don’t encourage DAO pattern
  11. Getting Database connection in pure JPA setup
  12. Hibernate and no PK
  13. Hibernate SessionFactory vs. JPA EntityManagerFactory
  14. annotation to filter results of a @OneToMany association
  15. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  16. Is it possible to dynamically define column names in Hibernate / JPA?
  17. JPA (Hibernate) and custom table prefixes
  18. Hibernate: “Field ‘id’ doesn’t have a default value”
  19. JPA: what is the proper pattern for iterating over large result sets?
  20. JPA Query.getResultList() – use in a generic way
  21. Create the perfect JPA entity [closed]
  22. Delete Not Working with JpaRepository
  23. Large Objects may not be used in auto-commit mode
  24. IllegalStateException with Hibernate 4 and ManyToOne cascading
  25. Force refresh of collection JPA entityManager
  26. Hibernate native query – char(3) column
  27. Hibernate triggering constraint violations using orphanRemoval
  28. JPA: How do I specify the table name corresponding to a class at runtime?
  29. How to force Hibernate to return dates as java.util.Date instead of Timestamp?
  30. Change Table Name of an Entity on runtime? [duplicate]

Leave a Comment