Eclipse Community Forums: EclipseLink » Oracle Outer Join syntax

Help

Home

Home » Eclipse Projects » EclipseLink » Oracle Outer Join syntax(EclipseLink 2.1)

Show: Today's Messages :: Show Polls :: Message Navigator

Oracle Outer Join syntax [message #554646]

Mon, 23 August 2010 20:12

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 20:25

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 13:53

James Sutherland

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 00:01:02 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter