Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Date: Thu, 26 Sep 2013 08:29:02 +0000 (UTC)
From: "axel becker (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Message-ID: <JIRA.12670657.1380184118360.22829.1380184142434@arcas>
In-Reply-To: <JIRA.12670657.1380184118360@arcas>
References: <JIRA.12670657.1380184118360@arcas>
Subject: [jira] [Created] (OPENJPA-2431) Native-Query with multiple joins to
 same table returning wrong result
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

axel becker created OPENJPA-2431:
------------------------------------

             Summary: Native-Query with multiple joins to same table returning wrong result
                 Key: OPENJPA-2431
                 URL: https://issues.apache.org/jira/browse/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 returnvalues. 
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 instance). 
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: https://issues.apache.org/jira/browse/openjpa-2218. 

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: http://www.atlassian.com/software/jira