Eclipse Community Forums: EclipseLink » Oracle Outer Join syntax

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

Oracle Outer Join syntax [message #554646]

Mon, 23 August 2010 16:12

Eclipse User

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

Eclipse User

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

Eclipse User

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).

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

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Nov 03 17:11:00 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter