Hi, I am new to JPA and I have this issue... I need to get an entity from the database based on the phone number and if the phone number exists my code works fine but throws javax.persistence.NoResultException: No entity found for query if the number does not. All I want ot do is to return null if the phone number does not exist in the database. Can any body help me with this..
Execute a SELECT query that returns a single result.
Returns: the result Throws: NoResultException - if there is no result NonUniqueResultException - if more than one result IllegalStateException - if called for a Java Persistence query language UPDATE or DELETE statement
So why dont you try the other getResultList() API by setting the maxResults to 1 as follows: