How to catch EntityNotFoundException

[Roland Barcia]

It seems that if I execute an EJB 3 query with JBoss and it returns an empty resultset, I cannot catch EntityNotFoundException. It seems that an aspect intercepts somewhere and does not allow me to respond.

I need to be able to detect in the session if the entity exist. If it does I update it. If not, I create a new one. I am testing the if not part but I can never get past EntityNotFoundException even if I catch it from the component calling the query.

Oh horray for aspect

[norman richards]

What do you mean "cannot catch" it? JBoss certainly throws it and it doesn't get caught by anything else. Here's a method I wrote just last week:

 
public int totalInventory() {
    try {
        return (Integer) em.createQuery("select sum(o.quantity) from Inventory o").getSingleResult();
   } catch (EntityNotFoundException e) {
        return 0;
   }
}

I this is the case because I forgot to think about the case when the application starts and there are no inventory items to sum. I was getting EntityNotFoundExceptions.
[ July 26, 2005: Message edited by: norman richards ]