Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsLeft Outer Join With Curly Brackets
https://www.eclipse.org/forums/index.php/mv/msg/204569/654253/#msg_654253
This driver implements SQL Ansi.
We are using eclipselink without specifying a TargetDataBase. All jpql queries are translated to sql ansi format and we had no problem so far.
But, we are facing a problem with a 'Left Outer Join'. The sql command is being build in a 'weird' way:
SELECT FROM {oj KICC66D t1 LEFT OUTER JOIN KICC110D t0 ON (t0.K110_ORG_REG = t1.K66_ORG_REG)}
This driver is complaining about the curly brackets.
Three questions:
- is this format with curly brackets correct for SQL ANSI ?
- what's the best TargetDataBase in order to generate just SQL ANSI format ?
- is there a property to say to eclipselink not to use curly brackets to build a left join command?
Thanks. ]]>Mauro Flores2011-02-14T18:56:36-00:00Re: Left Outer Join With Curly Brackets
https://www.eclipse.org/forums/index.php/mv/msg/204569/654903/#msg_654903
You can disable it by defining your own DatabasePlatform subclass and defining the method,
shouldUseJDBCOuterJoinSyntax() {
return false;
}
Then set your platform using the "eclipselink.target-database" persistence.xml property.
If you databases syntax differs than the standard, you can refer to the source code for the other platform subclasses in, org.eclipse.persistence.platform.database.
]]>James Sutherland2011-02-17T14:58:45-00:00