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

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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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
        curtisr7 Rick Curtis added a comment -

        Merged changes from trunk to 2.2.x.

        Show
        curtisr7 Rick Curtis added a comment - Merged changes from trunk to 2.2.x.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development