JPA getSingleResult() or null

by

Throwing an exception is how getSingleResult() indicates it can’t be found. Personally I can’t stand this kind of API. It forces spurious exception handling for no real benefit. You just have to wrap the code in a try-catch block.

Alternatively you can query for a list and see if its empty. That doesn’t throw an exception. Actually since you’re not doing a primary key lookup technically there could be multiple results (even if one, both or the combination of your foreign keys or constraints makes this impossible in practice) so this is probably the more appropriate solution.

More Related Contents:

  1. How can I make a JPA OneToOne relation lazy
  2. Can someone explain mappedBy in JPA and Hibernate?
  3. When and why JPA entities should implement the Serializable interface?
  4. Spring Boot – Cannot determine embedded database driver class for database type NONE
  5. JPA : How to convert a native query result set to POJO class collection
  6. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  7. Handling soft-deletes with Spring JPA
  8. Getting Database connection in pure JPA setup
  9. Hibernate and no PK
  10. When does the JPA set a @GeneratedValue @Id
  11. JPA @OneToOne with Shared ID — Can I do this Better?
  12. No Persistence provider for EntityManager named X
  13. JPA or JDBC, how are they different?
  14. How to introduce multi-column constraint with JPA annotations?
  15. Spring-Data FETCH JOIN with Paging is not working
  16. Limit number of results in JPQL
  17. stream on JPA lazy list
  18. Why use returned instance after save() on Spring Data JPA Repository?
  19. JPA Multiple Embedded fields
  20. Use abstract super class as parameter for Spring data repository
  21. JPA (Hibernate) and custom table prefixes
  22. Are you supposed to have one repository per table in JPA?
  23. Create the perfect JPA entity [closed]
  24. JPA using multiple database schemas
  25. PersistenceUnit vs PersistenceContext
  26. Hibernate native query – char(3) column
  27. What properties does @Column columnDefinition make redundant?
  28. DAO and Service layers (JPA/Hibernate + Spring) [duplicate]
  29. JPA Updating Bidirectional Association
  30. Does JPA support mapping to sql views?

Leave a Comment