[
https://issues.apache.org/jira/browse/OPENJPA-2651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Heath Thomann updated OPENJPA-2651:
-----------------------------------
Attachment: SqlResultSetMappingIssue.zip
I am attaching a crude/unpolished test which can be used to recreate the
reported issue. The entities involved and SQL involved are rather large. As
such I am not able to boil down this test into something suitable for a
JUnit.....maybe some day.....
To run the test you can edit the .classpath to suit your environment. The .zip
contains a file named create.sql to set up the database (this is for DB2). You
can then import the .zip into Eclipse, or your favorite IDE, and run the test
named MainStocks.
Thanks,
Heath
> IDs of entities are incorrectly assigned when @SqlResultSetMapping is used
> with inheritance and a ManyToOne relationship.
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-2651
> URL: https://issues.apache.org/jira/browse/OPENJPA-2651
> Project: OpenJPA
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.2.3, 2.4.2
> Reporter: Heath Thomann
> Assignee: Heath Thomann
> Priority: Critical
> Attachments: SqlResultSetMappingIssue.zip
>
>
> I have discovered an issue with using @SqlResultSetMapping when inheritance
> and ManyToOne relationships are used. To explain the issue, take this entity
> and @SqlResultSetMapping:
> @Entity
> @SqlResultSetMapping(name = "MyResMap", entities = {
> @EntityResult(entityClass = CrtRequisicaoChequePersEntity.class, fields = {
> @FieldResult(name = "crtOperacaoByOperacaoRecepcaoServCent.id", column =
> "opRecepcaoServCentraisId"),
> @FieldResult(name = "crtOperacaoByOperacaoRecepcaoServCent.dataHora",
> column = "opRecepcaoServCentraisDataHora")
> })
> })
> public class CrtRequisicaoChequePersEntity extends CrtRequisicaoEntity {
> .......
> @ManyToOne
> @javax.persistence.JoinColumn(name = "OPERACAO_RECEPCAO_SERV_CENT",
> referencedColumnName = "ID")
> private CrtOperacaoEntity crtOperacaoByOperacaoRecepcaoServCent;
> As you can see, this entity extends 'CrtRequisicaoEntity' and has a ManyToOne
> relationship to 'CrtOperacaoEntity', with name
> 'crtOperacaoByOperacaoRecepcaoServCent'. As you can see, the @FieldResult in
> the @SqlResultSetMapping references the fields in 'CrtOperacaoEntity'.
> These two entities are defined as follows:
> @Entity
> @Inheritance(strategy = InheritanceType.JOINED)
> public class CrtRequisicaoEntity {
> .....
> @Id
> private long id;
> .....
> @Entity
> public class CrtOperacaoEntity implements Serializable {
> .....
> @Id
> private long id;
> @Basic
> private Timestamp dataHora;
> With these entities, take an SQL select which uses an AS (the entire SQL is
> to long to add here, see provided recreate/test attached):
> String sqlCust = "SELECT t0.ID" +
> .........
> ",t2.DATA_HORA as opRecepcaoServCentraisDataHora" +
> ",t2.ID as opRecepcaoServCentraisId" +
> ....
> "FROM CrtRequisicaoChequePersEntity t0"
> ....
> "INNER JOIN CrtOperacaoEntity t2"
> ....
> With this SQL, the two IDs will be populated with the ID from
> CrtRequisicaoChequePersEntity, rather than the ID corresponding to each
> entity.
> Thanks,
> Heath
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
