openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "axel becker (JIRA)" <>
Subject [jira] [Created] (OPENJPA-2431) Native-Query with multiple joins to same table returning wrong result
Date Thu, 26 Sep 2013 08:29:02 GMT
axel becker created OPENJPA-2431:

             Summary: Native-Query with multiple joins to same table returning wrong result
                 Key: OPENJPA-2431
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc, jpa, kernel, sql
    Affects Versions: 2.1.1, 2.1.0
         Environment: Websphere 8 Runtime and ApplicationServer
Windows XP
J2EE 6
Oracle 11
            Reporter: axel becker
            Priority: Critical

The resultset of the following native query should has a result of an objectarray with 3 different
1) TestEntityIndexReadonly: the holder entity mapped to table indexes 
2) TestEntityCurrencyReadonly: currency mapped to table types 
3) TestEntityTenorReadonly: tenor mapped to table types too 

But i get an Resultset with 3 Objects where the second and the third object are the same (same
1) TestEntityIndexReadonly: 
2) TestEntityCurrencyReadonly: 
3) TestEntityCurrencyReadonly: 

Hint: For the entity-3 i get the same oid as for entity-2. The reason is, the JDBCStoreManager
(Line 1031) "Object oid = base.getObjectId(this, result, null, true, null);" gets the same
oid for entity-2 and entity-3. 

I will attache the javaclasses and mapping.xml and a screen from the wrong resultset. 

see also: 

I tried to find out a workaround by removing the abstract parent from TestEntityCurrencyReadonly
and TestEntityTenorReadonly. 
In this case, i get the correct Objectinstances but the third entity (TestEntityTenorReadonly)
holds the values from TestEntityCurrencyReadonly (also wrong)! 

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message