EJB-QL query never returning unless another query is run

Posted by KevMo on Stack Overflow See other posts from Stack Overflow or by KevMo
Published on 2010-03-30T01:10:09Z Indexed on 2010/03/30 1:13 UTC
Read the original article Hit count: 512

Filed under:

toplink

|

ejbql

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?

© Stack Overflow or respective owner

Related posts about toplink

Netbeans / persistence API error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am following this tutorial, I'm using netbeans 6.5.1 http://www.netbeans.org/kb/docs/java/gui-db-custom.html When I get to the part where I create the "new entity class from database", which is in the "Customizing the Master/Detail View" section of the tutoiral. I can't ever compile because I… >>> More
specify query timeout when using toplink essential query hint

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, For glassfish v2, I have searched through the web and I cannot find anyway to specify query timeout when using TopLink essential query hint. We have another option to migrate to EclipseLink but that is not feasible. have tried the solution in http://forums.oracle.com/forums/thread.jspa?threadID=974732&tstart=-1 but… >>> More
Toplink Exception, whats wrong?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I've got an excpetion when I generate this EJB SQL Statement. Exception Description: Syntax error parsing the query [SELECT h FROM Busmodul h WHERE LOWER(h.modulNummer) LIKE :modulnummer AND h.einbauort.id = :einbauort_fk AND h.plattform.id = :plattform_fk ORDER BY TRIM(TRAILING '-' FROM… >>> More
Regarding Toplink Fetching Policy

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm working for a Swing Project and the technologies used are netbeans with Toplink essentials, mysql. The Problem I'm facing is the entity object dosn't get updated after insertions take place while calling a getter collection of the foreign key property. Ex: I have 2 tables Table1,Table2… >>> More
Toplink client session

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any way i can access the object of one client session from another client session? >>> More

Related posts about ejbql

iReport ejbql connection

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to create ejbql connection in iReport, i have added all the related jars. Set the classpath to include the META-INF directory containing persistence.xml & jars. On testing connection it shows nothing, but in console it prints "java.lang.NoClassDefFoundError: Could not initialize class org… >>> More
EJB-QL query never returning unless another query is run

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
Is this valid EJB-QL?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following construct in EJB-QL several EJB 2.1 finder methods: SELECT distinct OBJECT(rd) FROM RequestDetail rd, DetailResponse dr WHERE dr.updateReqResponseParentID is not null and dr.updateReqResponseParentID = ?1 and rd.requestDetailID = dr.requestDetailID … >>> More
Converting Oracle date arithmetic to work in HSQLDB

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to spot-test an Oracle backed database with hsqldb and dbunit, but I've run into a snag. The problem is with the following EJB-QL (simplified a bit): SELECT o FROM Offer o WHERE :nowTime BETWEEN o.startDate AND o.startDate + 7 This seems to only work in Oracle's version of SQL… >>> More
Out of Memory When Loading Java Entities

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a terrible problem that hopefully has a very simple answer. I am running out of memory when I perform a basic If I have code like this: MyEntity myEntity; for (Object id: someIdList) { myEntity = find(id); // do something basic with myEntity } And the find() method is a standard… >>> More