-
1. Re: Hibernate Oracle Problem: ORA-00907: missing right paren
deanouk Sep 13, 2007 7:06 AM (in response to deanouk)Just to let you know the query...
I have two tables.
Users and UserSurveys
There is a one-to-many mapping between
Users to UserSurveys.
I'm trying to perform a query like to get users who haven't completed a survey before 'purchaseDate':
Query query = entityManager.createQuery("FROM " + User.class.getSimpleName()
+ " cu LEFT JOIN FETCH cu.userSurveys us"
+ " WHERE cu.purchaseDate <= :purchaseDate");
query.setParameter("purchaseDate", new java.sql.Date(cal.getTimeInMillis()), TemporalType.DATE);
That's it. -
2. Re: Hibernate Oracle Problem: ORA-00907: missing right paren
deanouk Sep 13, 2007 7:11 AM (in response to deanouk)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)"); -
3. Re: Hibernate Oracle Problem: ORA-00907: missing right paren
deanouk Sep 13, 2007 8:59 AM (in response to 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. -
4. Re: Hibernate Oracle Problem: ORA-00907: missing right paren
deanouk Sep 14, 2007 4:37 AM (in response to deanouk)I'm going to have to assume this is a bug and raise it with both JBoss and Hibernate unless anyone has any further ideas?