[OPENJPA-541] Generate SQL92 JOIN syntax for Oracle 9 or later releases

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.0.3, 1.1.0
• Fix Version/s: 1.0.3, 1.1.0
• Component/s: sql
• Assignee: Catalina Wei
• Reporter: Catalina Wei
• Created: 21/Mar/08 00:35
• Updated: 09/Mar/10 18:32
• Resolved: 18/Apr/08 16:38

Description

Oracle 8 JOIN syntax is produced for Oracle 10g reported from a customer.
Oracle 9 or later release do support SQL92 JOIN syntax.

Should we fix it in OracleDictionary ?

The proposed fix is :
change the initial setting of
joinSyntax = SYNTAX_DATABASE; ==> joinSyntax = SYNTAX_SQL92;

I am not sure whether this fix affecting those accessing Oracle thru jdbc:datadirect.

Could anyone familiar with datadirect comment on this fix ?
Thanks.

Catalina