JPA Native Query set null parameter

by

I have faced the same issue when use EntityManager.createNamedQuery(guess the same issue with createNativeQuery).

In case you are going to pass nullable parameter to Query then use TypedParameterValue which allows to pass the type.

For instance:

setParameter("paramName", new TypedParameterValue(StandardBasicTypes.LONG, paramValue));

Here you explicitly set the type of passed value and when you pass null value as processor know the exact type.

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. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  4. Can someone explain mappedBy in JPA and Hibernate?
  5. When and why JPA entities should implement the Serializable interface?
  6. Spring Boot – Cannot determine embedded database driver class for database type NONE
  7. JPA : How to convert a native query result set to POJO class collection
  8. Why does JPA have a @Transient annotation?
  9. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  10. How to persist a property of type List in JPA?
  11. Handling soft-deletes with Spring JPA
  12. Getting Database connection in pure JPA setup
  13. Hibernate and no PK
  14. When does the JPA set a @GeneratedValue @Id
  15. Java – JPA – @Version annotation
  16. JPA @OneToOne with Shared ID — Can I do this Better?
  17. annotation to filter results of a @OneToMany association
  18. Parameter in like clause JPQL
  19. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  20. Is it possible to dynamically define column names in Hibernate / JPA?
  21. JPA Multiple Embedded fields
  22. Hibernate: “Field ‘id’ doesn’t have a default value”
  23. How to use @Transactional with Spring Data?
  24. @Basic(optional = false) vs @Column(nullable = false) in JPA
  25. Delete Not Working with JpaRepository
  26. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  27. What is a JPA implementation?
  28. JPA Updating Bidirectional Association
  29. How to find distinct rows with field in list using JPA and Spring?
  30. Does JPA support mapping to sql views?

Leave a Comment