Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-541

Generate SQL92 JOIN syntax for Oracle 9 or later releases

    Details

    • 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
    • Labels:
      None

      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

        Attachments

          Activity

            People

            • Assignee:
              fancy Catalina Wei
              Reporter:
              fancy Catalina Wei
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: