Thanks. About what I thought. Just wanted to check.
On Mon, Apr 13, 2009 at 12:41 PM, Mike Kienenberger <[email protected]>wrote: > By the way, when I say "could be added back in", I am not volunteering > to do the work, only letting you know that you could probably figure > out how to submit patches to do this by looking at Cayenne 2 code and > porting to Cayenne 3. > > On Mon, Apr 13, 2009 at 12:40 PM, Mike Kienenberger <[email protected]> > wrote: > > Yes, you need Oracle 9 before that syntax is understood. > > > > Oracle 8 only understands select * from t1, t2 where t1.x = t2.x. I > > suppose the old oracle inner join support could be added back in. > > > > Outer join support is even worse for 8, and not implementable for all > > practical purposes. > > > > > > On Mon, Apr 13, 2009 at 12:32 PM, Bryan Lewis <[email protected]> > wrote: > >> We have some apps running on an Oracle 8i database. Wow, almost 10 > years > >> old. Cayenne 2 has been working great. When I tried updating to > Cayenne 3, > >> I got a syntax error in a particular bit of SQL with a JOIN. This isn't > an > >> urgent problem for us but I thought I'd mention it. > >> > >> We have an Employee entity with a many-to-many relationship to Role. > With a > >> join table called Employee_Role. > >> > >> List roles = employee.getRoles(); > >> Role role = roles.get(0); > >> > >> The first fetch works but resolving the first element generates this > SQL: > >> > >> SELECT DISTINCT t0.* FROM ROLE t0 > >> JOIN EMPLOYEE_ROLE t1 ON > >> (t0.ROLE_ID = t1.ROLE_ID) > >> WHERE t1.EMPLOYEE_ID = ? [bind: 1:312] > >> > >> Oracle 8i doesn't understand that JOIN...ON syntax and throws: > >> > >> java.sql.SQLException: ORA-00933: SQL command not properly ended > >> > >> The same code works fine on PostgreSQL with almost the same generated > SQL. > >> > > >
