Noob query problem :/ simple select clause.

[yacho]

Im using Seam in general but this one is about EJB-QL only i think...

i have a following query :

User existing = (User) em.createQuery("SELECT OBJECT(u) FROM User u WHERE u.login=#{newUser.login} AND u.passwdHash=#{newUser.passwdHash}").getSingleResult();

and i constantly get such Exception :

Exception during request processing:
Caused by javax.servlet.ServletException with message: "#{userManager.register}: javax.ejb.EJBTransactionRolledbackException: No entity found for query"

As far as i know if query returns no results it should return null ... so how to deal with it ?

[weston.price]

http://java.sun.com/javaee/5/docs/api/

As per the API specification, the getSingleResult() method should throw a NoResultException if an entity cannot be found. You are simply seeing the original exception chained. To execute without throwing an exception you will need to use the

getResultList()

method.

[yacho]

Yes - i figured that out after posting on Seam's forum.

One more thing. Basically Seam always get's me chainded exceptions and its hard to know what's what. - is there a way to print only part of a stack trace wich is directly responsible for exception (all i know i can use is getMesage and getStackTrace())