Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Oracle Outer Join syntax(EclipseLink 2.1)
Oracle Outer Join syntax [message #554646] Mon, 23 August 2010 20:12 Go to next message
Dave Staelens is currently offline Dave StaelensFriend
Messages: 4
Registered: August 2010
Junior Member
I've just upgraded to EclipseLink 2.1, but the project I had running is now failing due to syntactical SQL query problems on outer joins. The database is still a version 8 Oracle database, but EclipseLink is generating LEFT OUTER JOIN ON syntax, where this version only supports the (+) syntax. Is there a way to pass hints to EclipseLink to go back to the old style join generated syntax?

Thanks,
Dave
Re: Oracle Outer Join syntax [message #554648 is a reply to message #554646] Mon, 23 August 2010 20:25 Go to previous messageGo to next message
Dave Staelens is currently offline Dave StaelensFriend
Messages: 4
Registered: August 2010
Junior Member
If I revert back to 2.02, it works fine....
Confused
Re: Oracle Outer Join syntax [message #555399 is a reply to message #554646] Thu, 26 August 2010 13:53 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

To use the old outer join syntax set,

session.getPlatform().setPrintOuterJoinInWhereClause(true)

in your OraclePlatform (i.e. using a SessionCustomizer, or creating your own platform subclass).

Please log a bug that the Oracle8Platform should set this (and the Oracle9Platform should revert it).


James : Wiki : Book : Blog : Twitter
Previous Topic:NullPointerException in class ObjectReferenceMapping
Next Topic:unidirectional ManyToMany with an order?
Goto Forum:
  


Current Time: Mon Nov 24 21:45:45 GMT 2014

Powered by FUDForum. Page generated in 0.05807 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software