Hi Everyone,

Working on an issue with Hibernate - we needed to do a change in a HQL that now includes a "not exists" to the HQL. If I pull the HQL and put it as SQL, it functions properly - but when I run the app itself, it returns no rows.

Here is the HQL:

"from " + trafficStatus.class.getName() + " s, " + eventQueue.class.getName() + " b " +
"where s.availableFlag = 'Y' " +
"and s.deliveryFlag = 'Y' " +
"and s.code= b.code" +
"and b.processedFlag = 'N' " +
"and (not exists (SELECT c.value " +
"from " + config.class.getName() + " c " +
"where c.code= b.code" +
" and c.pmsType = 'O' " +
" and c.key = 'key' " +
" and c.value = 'Y') " +
"or b.createdTimestamp < :timeDelayDate) ";


Any ideas about this "not exists" problem?

Thanks, Michael

Well - one needed piece of information is



The code was trying to exclude rows that didn't have have a created date of less than a minute (yeah, crazy, but that is what the business needs). Using the "setDate" apparently was striping off the time value and messing up the comparsion and not returning any rows. Changing it to either setTime or setParameter resulted in the rows being returned.

Therefore - BE careful setting values on the HQL...

Michael