[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Hibernate Oracle Problem: ORA-00907: missing right paren
DeanoUK
do-not-reply at jboss.com
Thu Sep 13 07:11:24 EDT 2007
Query query = entityManager.createQuery("FROM " + User.class.getSimpleName()
+ " cu LEFT JOIN FETCH cu.userSurveys us"
+ " WHERE cu.purchaseDate <= :purchaseDate"
+ " AND NOT EXISTS (SELECT us FROM cu.userSurveys us WHERE us.userId = cu.userId)");
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4083872#4083872
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4083872
More information about the jboss-user
mailing list