OpenJPA
  1. OpenJPA
  2. OPENJPA-541

Generate SQL92 JOIN syntax for Oracle 9 or later releases

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major 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

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        21h 13m 1 Catalina Wei 21/Mar/08 21:49
        Resolved Resolved Reopened Reopened
        27d 18h 48m 1 Michael Dick 18/Apr/08 17:38
        Reopened Reopened Resolved Resolved
        12s 1 Michael Dick 18/Apr/08 17:38
        Resolved Resolved Closed Closed
        690d 1h 54m 1 Donald Woods 09/Mar/10 18:32
        Donald Woods made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Michael Dick made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Won't Fix [ 2 ]
        Michael Dick made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Hide
        Michael Dick added a comment -

        These changes have been backed out. I'm re-opening so that it can be marked as such.

        Show
        Michael Dick added a comment - These changes have been backed out. I'm re-opening so that it can be marked as such.
        Catalina Wei made changes -
        Field Original Value New Value
        Fix Version/s 1.0.3 [ 12312969 ]
        Resolution Fixed [ 1 ]
        Fix Version/s 1.1.0 [ 12312344 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Catalina Wei created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development