[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Hibernate Oracle Problem: ORA-00907: missing right paren

[DeanoUK]

To make it even simpler I've done:

Query query = entityManager.createQuery("FROM " + User.class.getSimpleName()
						+ " cu LEFT JOIN cu.userSurveys us"
						+ " WHERE NOT EXISTS (SELECT us FROM cu.userSurveys us WHERE us.userId = cu.userId)");

Still the same problem.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4083925#4083925

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4083925