wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes javax. persistence. NoResultException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "javax. persistence. NoResultException" Watch "javax. persistence. NoResultException" New topic
Author

javax. persistence. NoResultException

Sam Venkata
Ranch Hand

Joined: Mar 06, 2006
Posts: 68
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..

my code is as follows..



Can some body help me with this...

Thanks,
Samanth.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 9947
    
161

Originally posted by Samanth Marisetty:
try{
if(devicesQuery.getSingleResult()!= null){

result = (User) devicesQuery.getSingleResult();
}
}catch(javax.persistence.NoResultException nre){

}


As per the Javadocs of this API:

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:



[My Blog] [JavaRanch Journal]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: javax. persistence. NoResultException
 
Similar Threads
Problem javax.persistence.NoResultException: No entity found for query
User Authentication Mechanism
Servlet calling EJB - compiling problems
security migration from weblogic to Jboss
cannot find symbol