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
