OpenJPA
  1. OpenJPA
  2. OPENJPA-2162

Avoid delimited identifier processing if it's not required by application

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.1, 2.3.0
    • Fix Version/s: 2.2.1, 2.3.0
    • Component/s: jdbc, performance, sql
    • Labels:
      None

      Description

      Supporting delimited identifiers causes some unnecessary overhead if the application and associated database doesn't use them or support them. This change will surface the DBDictionary property supportsDelimitedIdentifiers. Currently, this property gets set by querying the database to see if the database supports this capability. With this change, we will first check if this property has been explicitly set. If explicitly set, then we'll use that value. Otherwise, we will default back to querying the database to determine whether to support delimited identifiers or not.

      Here's an example of the property to set to turn off the delimited identifier support:

      <property name="openjpa.jdbc.DBDictionary" value="db2(SupportsDelimitedIdentifiers=false)"/>

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        58d 18h 1 Rick Curtis 25/May/12 15:31
        Resolved Resolved Closed Closed
        137d 4h 9m 1 Albert Lee 09/Oct/12 19:40
        Albert Lee made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Rick Curtis made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.3.0 [ 12319463 ]
        Fix Version/s 2.2.1 [ 12319943 ]
        Resolution Fixed [ 1 ]
        Hide
        Rick Curtis added a comment -

        Merged changes from trunk to 2.2.x.

        Show
        Rick Curtis added a comment - Merged changes from trunk to 2.2.x.
        Kevin Sutter created issue -

          People

          • Assignee:
            Kevin Sutter
            Reporter:
            Kevin Sutter
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development