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 16:12 Go to next message
Dave Staelens is currently offline Dave Staelens
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

Report message to a moderator

Re: Oracle Outer Join syntax [message #554648 is a reply to message #554646] Mon, 23 August 2010 16:25 Go to previous messageGo to next message
Dave Staelens is currently offline Dave Staelens
Messages: 4
Registered: August 2010
Junior Member
If I revert back to 2.02, it works fine....
Confused

Report message to a moderator

Re: Oracle Outer Join syntax [message #555399 is a reply to message #554646] Thu, 26 August 2010 09:53 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1844
Registered: July 2009
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

Report message to a moderator

Previous Topic:NullPointerException in class ObjectReferenceMapping
Next Topic:unidirectional ManyToMany with an order?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 25 01:30:35 EDT 2013

Powered by FUDForum. Page generated in 0.15472 seconds