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

        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.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development