[jira] Created: (OPENJPA-1658) Enhance OpenJPA Support of Polymorphic Tables

["Pat Grady (JIRA)" <ji...@apache.org>]

Enhance OpenJPA Support of Polymorphic Tables
---------------------------------------------

                 Key: OPENJPA-1658
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1658
             Project: OpenJPA
          Issue Type: Improvement
          Components: jpa
    Affects Versions: 1.2.2
         Environment: WebSphere Application Server on Linux and DB2 on AIX
            Reporter: Pat Grady


I'm building an application using polymorphic tables or more specifically a joined table pattern.  The discriminator column is implemented in DB2 9.5 as a char(10) field and the discriminator value is variable in its length.  The behavior within the application is that I can create and persist the object with no issues.  When attempting to retrieve objects, no objects return.  Tracing the issue shows that JPA is finding the object but not returning it because the persisted value space-padded to 10 characters (as is expected in a char field) does not equal the non-space-padded value in the .java files.  If I change the DB column to varchar, everything works as expected; my DBA wants the char field for performance reasons.  Suggest providing a switch of some sort (e.g., a value in an annotation tag) to treat the discriminator column comparison as trimmed to support a persisted char value.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.