openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adam Hardy <adam....@cyberspaceroad.org>
Subject Re: simple join issue
Date Fri, 18 Jan 2008 12:09:45 GMT
Would it be appropriate if I raised the status of this issue to Blocker?

https://issues.apache.org/jira/browse/OPENJPA-496

It appears that there is no work-around and it certainly isn't possible to run 
my application with the data appearing in the wrong forms.

Regards
Adam


Patrick Linskey on 17/01/08 17:30, wrote:
> Hi,
> 
> If you could upload a unit test, that would be great.
> 
> -Patrick
> 
> On Jan 17, 2008 5:31 AM, Adam Hardy <adam.sql@cyberspaceroad.org> wrote:
>> OpenJPA is mixing up the mapping of columns from joined tables, where the two
>> tables have fields with the same name used on their respective entities. I've
>> got some basic unit tests aimed at verifying the problem. Is there something
>> wrong with my mappings or is this a bug? I can upload the unit test project.
>>
>> Here's the info. The TITLE fields get mixed up. I have this query:
>>
>> select species from Species species
>>
>> I have this output:
>>
>> SELECT t0.ID, t1.ID, t1.OWNER_ID, t1.TITLE, t0.IUCN_STATUS_ID, t0.OWNER_ID,
>> t0.TITLE FROM PUBLIC.SPECIES t0 LEFT OUTER JOIN PUBLIC.GENUS t1 ON t0.GENUS_ID =
>> t1.ID
>>
>> These are the mappings:
>>
>>    <entity class="org.permacode.atomictest.domain.Genus">
>>      <table name="GENUS" />
>>      <attributes>
>>        <id name="id">
>>          <column name="ID" />
>>          <generated-value strategy="TABLE" generator="genusKeySequence" />
>>        </id>
>>        <basic name="title">
>>          <column name="TITLE" />
>>        </basic>
>>        <basic name="ownerId">
>>          <column name="OWNER_ID" />
>>        </basic>
>>        <one-to-many name="species" mapped-by="genus">
>>          <cascade>
>>            <cascade-persist />
>>            <cascade-merge />
>>            <cascade-refresh />
>>          </cascade>
>>        </one-to-many>
>>      </attributes>
>>    </entity>
>>
>>    <entity class="org.permacode.atomictest.domain.Species">
>>      <table name="SPECIES" />
>>      <attributes>
>>        <id name="id">
>>          <column name="ID" />
>>          <generated-value strategy="TABLE" generator="speciesKeySequence" />
>>        </id>
>>        <basic name="title">
>>          <column name="TITLE" />
>>        </basic>
>>        <basic name="iucnStatus">
>>          <column name="IUCN_STATUS_ID" />
>>          <enumerated>ORDINAL</enumerated>
>>        </basic>
>>        <basic name="ownerId">
>>          <column name="OWNER_ID" />
>>        </basic>
>>        <many-to-one name="genus">
>>          <join-column name="GENUS_ID" />
>>        </many-to-one>
>>      </attributes>
>>    </entity>
>>
> 
> 
> 


Mime
View raw message