tags:

views:

41

answers:

0

I have a strange strange problem.

When executing the following EJB-QL query, my ENTIRE application will stop responding to requests, as the query never finishes executing.

Query q = em.createQuery("SELECT o from RoomReservation as o WHERE o.deleted = FALSE AND o.room.id IN (Select r.id from Room as r where r.deleted = FALSE AND r.type.name = 'CLASSROOM')");

However, if I execute this query before I execute the other query, it runs without issue.

Query dumbQuery = em.createQuery("SELECT o from Room as o WHERE o.deleted = FALSE");

Any idea what in the world is going on?