Re: [Hibernate] Outer join question - apologies

2003-11-08 Thread Troy McKinnon
.QueryException: dereferenced: upcasin1_.auditInfo.lastUpdated Troy - Original Message - From: "Gavin King" <[EMAIL PROTECTED]> To: "Troy McKinnon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, November 08, 2003 2:10 AM Subject: Re: [Hibernate] Outer

Re: [Hibernate] Outer join question - apologies

2003-11-08 Thread Gavin King
Actually you can't. Did this work? I wouldn't rely upon it... Troy McKinnon wrote: Sorry everyone - I didn't realize you could use straight sql in the createQuery() method. Anyway for those who might not know: Query q = session.createQuery( "select count(x.name) from Table_1

Re: [Hibernate] Outer join question

2003-11-08 Thread Gavin King
No, where clause (theta-style) joins are only supported for inner joins. HQL has no "ON" (yet). Troy McKinnon wrote: I have been reading thru the documentation on the hibernate query language regarding joins and other 'sql' queries. I noticed that in every case of a join the 2 tables have an ass

Re: [Hibernate] Outer join question - apologies

2003-11-08 Thread Troy McKinnon
Sorry everyone - I didn't realize you could use straight sql in the createQuery() method. Anyway for those who might not know: Query q = session.createQuery( "select count(x.name) from Table_1 x, Table_2 y "+ " where length (x.name) > 11 and x.name= y.name(+) and