Could you please log a bug report in Jira: http://issues.apache.org/jira/browse/CAY
Thanks,
Andrus
On Jul 10, 2009, at 10:49 AM, Donald Vrakking wrote:
> It is indeed related to the inheritance. I created a small project
> with just these two classes to make experimenting a lot easier ;-)
>
> Without the subentities (Organisation and Supplier), everything
> works as it should with 2.0.4 and 3.0M6.
>
> With the subentities and 3.0M6, the problem remains only when using
> a disjoint prefetch.
>
> Donald
>
>
> On 9 jul 2009, at 13:00, Andrus Adamchik wrote:
>
>> Hmm... could be a bug related to inheritance presence. Before we dig
>> any further, could you try it with Cayenne 3.0M6 (which should be
>> mostly compatible). Is the problem still there?
>>
>> Andrus
>>
>>
>> On Jul 9, 2009, at 12:23 PM, Donald Vrakking wrote:
>>
>>> There are to entities Supplier and Organisation. Both have a super
>>> entity SppSupplier and SppOrganisation, these are mapped to the
>>> tables. The query is done for Supplier(.class) and organisation is
>>> prefetched using toSppOrganisation.
>>>
>>> <db-entity name="SPP_SUPPLIER" schema="PRODUCTSUPPLIERUSER">
>>> ...attribs...
>>> <db-attribute name="ORGANISATION_ID" type="INTEGER" length="22"/>
>>> <db-attribute name="SUPPLIER_ID" type="INTEGER"
>>> isPrimaryKey="true" isMandatory="true" length="22"/>
>>> <db-key-generator>
>>> <db-generator-type>ORACLE</db-generator-type>
>>> <db-generator-name>seq_supplier</db-generator-name>
>>> <db-key-cache-size>1</db-key-cache-size>
>>> </db-key-generator>
>>> </db-entity>
>>>
>>>
>>> <db-entity name="SPP_ORGANISATION" schema="PRODUCTSUPPLIERUSER">
>>> ...attribs...
>>> <db-attribute name="ORGANISATION_ID" type="INTEGER"
>>> isPrimaryKey="true" isMandatory="true" length="22"/>
>>> <db-key-generator>
>>> <db-generator-type>ORACLE</db-generator-type>
>>> <db-generator-name>seq_organisation</db-generator-name>
>>> <db-key-cache-size>1</db-key-cache-size>
>>> </db-key-generator>
>>> </db-entity>
>>>
>>> <db-relationship name="toSppOrganisation" source="SPP_SUPPLIER"
>>> target="SPP_ORGANISATION" toMany="false">
>>> <db-attribute-pair source="ORGANISATION_ID"
>>> target="ORGANISATION_ID"/>
>>> </db-relationship>
>>>
>>>
>>> <obj-entity name="SppOrganisation"
>>> className="com.traserv.persist.productsupplier.SppOrganisation"
>>> dbEntityName="SPP_ORGANISATION"
>>> superClassName="com.traserv.persist.GenericDataObject">
>>> ...attribs...
>>> <obj-attribute name="name" type="java.lang.String" db-attribute-
>>> path="NAME"/>
>>> </obj-entity>
>>>
>>> <obj-entity name="Organisation" superEntityName="SppOrganisation"
>>> className="com.traserv.model.productsupplier.Organisation">
>>> </obj-entity>
>>>
>>>
>>> <obj-entity name="SppSupplier"
>>> className="com.traserv.persist.productsupplier.SppSupplier"
>>> dbEntityName="SPP_SUPPLIER"
>>> superClassName="com.traserv.persist.GenericDataObject">
>>> ...attribs...
>>> </obj-entity>
>>>
>>> <obj-entity name="Supplier" superEntityName="SppSupplier"
>>> className="com.traserv.model.productsupplier.Supplier">
>>> </obj-entity>
>>>
>>> <obj-relationship name="toSppOrganisation" source="SppSupplier"
>>> target="SppOrganisation" db-relationship-path="toSppOrganisation"/>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On 9 jul 2009, at 09:29, Andrus Adamchik wrote:
>>>
>>>> Very odd. This is as vanilla as it can get... Can you copy-paste
>>>> the
>>>> relevant parts of the DataMap? I.e. Obj and Db entities definitions
>>>> for both entities and relationships definitions.
>>>>
>>>> Andrus
>>>>
>>>>
>>>> On Jul 9, 2009, at 10:20 AM, Donald Vrakking wrote:
>>>>> It's an n..1 relation; entity A has a foreign key to the PK of B.
>>>>> The "to dep pk" flag is not set.
>>>>>
>>>>> Donald
>>>>>
>>>>>
>>>>> On 9 jul 2009, at 08:59, Andrus Adamchik wrote:
>>>>>
>>>>>> Let's look at the details of mapping of this relationship. Is it
>>>>>> mapped as 1..1 or 1..N? If it is 1..1, is there a "to dep pk"
>>>>>> flag
>>>>>> set
>>>>>> in one of the directions?
>>>>>>
>>>>>> Andrus
>>>>>>
>>>>>>
>>>>>> On Jul 8, 2009, at 12:43 PM, Donald Vrakking wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>>
>>>>>>> I have two objects A and B which have an m:1 relation (it's used
>>>>>>> as
>>>>>>> a 1:1). I created a SelectQuery to get instances of A and
>>>>>>> added a
>>>>>>> prefetch to B. After executing the query, A only has a
>>>>>>> toOneFault
>>>>>>> for B, so when I access B it will execute another
>>>>>>> (relationship)query on the database.
>>>>>>>
>>>>>>> It doesn't matter if I use a DISJOINT or a JOINT prefetch, the
>>>>>>> result is the same; all the necessary queries are executed and
>>>>>>> the
>>>>>>> datarows for B are put in the cache, but the property on A isn't
>>>>>>> updated with the prefetched B. Does anybody know how to explain
>>>>>>> (and fix ;-)) this?
>>>>>>>
>>>>>>> Thanx,
>>>>>>>
>>>>>>> Donald Vrakking
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
This archive was generated by hypermail 2.0.0 : Fri Jul 10 2009 - 04:06:11 EDT