John,
I think the proper syntax for nested fields is "::" not "->"
eg "status::modified" instead of "status->modified"
-----Original Message-----
From: LAURENT Stephane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 5:38 AM
To: OJB Users List
Subject: Re: Still not understanding why getCollectionByQuery() is not getting
sub-object.
Hi,
I'm now in RC4 but never have this kind of pb with RC2.
Just a difference for me, my repository contain this : <class-descriptor
class="com.jobbank.jobbank.model.offer.OfferVO" table="offer" refresh="true"> Not
this : <class-descriptor class="com.jobbank.jobbank.model.offer.OfferVO"
table="offer" auto-retrieve="true" auto-update="false" auto-delete="false"> But if
you can retrieve objects "manually", it's probably not your pb ...
I never seen this syntax before :"<field-descriptor name="status->modified" Can I see
your OrderItemVO object ? Is status a member of OrderItemVO ?
Regards.
St�phane LAURENT
----- Original Message -----
From: Robert J Celestino
To: OJB Users List
Sent: Tuesday, November 04, 2003 9:47 PM
Subject: RE: Still not understanding why getCollectionByQuery() is not getting
sub-object.
Hello John,
I am stumped too (not that says very much, I am a newbie to OJB).
Have you tried RC4?
Bob c
----------------------------------------------------------------
Bob Celestino
SAS Research and Development
919 - 531 - 9425
[EMAIL PROTECTED]
SAS - The Power to Know
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 04, 2003 2:03 PM
> To: OJB Users List
> Subject: Still not understanding why getCollectionByQuery()
> is not getting sub-object.
>
>
>
>
>
> Is anybody aware of anything in RC2 that would prevent
> getCollectionByQuery() from realizing sub-objects? I get
> N records using getCollectionByQuery() successfully, but
> this OfferVO subobject continues to not show its ugly head
> unless I manually get each sub-object.
>
> I have auto-retrieve="true" everywhere.
>
> I successfully get a different sub-reference on a different
> non-collection object. My mapping is correct in that manual
> retieval works.
>
> I thought sub-objects would be realized with
> getCollectionByQuery() unlike with getIteratorByQuery().
>
>
> I am wondering if it could have something to do with the
> fact that the Collection of OrderItemVO has 3 primary keys
> or something to do with the below setting in the
> OJB.properties I needed to allow for '->' Single Table
> Aggregation. '->' was only allowed as far as I know in RC2
> using this setting. I don't know if it was implemented in
> the default setting since.
>
> PersistentFieldClass=org.apache.ojb.broker.metadata.fieldacc
> ess.PersistentNestedFieldMaxPerformanceImpl
>
>
> My repository.xml as it is today for the two important
> tables follows:
>
>
>
> <!-- Definitions for the OrderItemVO object which is
> retrieved with the getCollectionByQuery() -->
> <class-descriptor
> class="com.jobbank.jobbank.model.order.OrderItemVO"
> table="orderitem">
> <field-descriptor
> name="offerId"
> column="offerid"
> jdbc-type="INTEGER"
> primarykey="true"
> />
> <field-descriptor
> name="memberId"
> column="mid"
> jdbc-type="INTEGER"
> primarykey="true"
> />
> <field-descriptor
> name="orderId"
> column="orderid"
> jdbc-type="INTEGER"
> primarykey="true"
> />
> <field-descriptor
> name="offerQuantity"
> column="offerquantity"
> jdbc-type="INTEGER"
> />
> <field-descriptor
> name="buyLater"
> column="buylater"
> jdbc-type="INTEGER"
>
> conversion="org.apache.ojb.broker.accesslayer.conversions.Bo
> olean2IntFieldConversion"
> />
> <field-descriptor
> name="status->modified"
> column="modified"
> jdbc-type="TIMESTAMP"
> />
> <field-descriptor
> name="status->added"
> column="added"
> jdbc-type="TIMESTAMP"
> />
> <field-descriptor
> name="status->disabled"
> column="disabled"
> jdbc-type="INTEGER"
>
> conversion="org.apache.ojb.broker.accesslayer.conversions.Bo
> olean2IntFieldConversion"
> />
> <reference-descriptor
> name="offer"
> class-ref="com.jobbank.jobbank.model.offer.OfferVO"
> auto-retrieve="true"
> auto-update="false"
> auto-delete="false">
> <foreignkey field-ref="offerId"/>
> </reference-descriptor>
> </class-descriptor>
>
>
>
>
> <!-- Definitions for the OfferVO object which won't
> retrieve itself automatically --> <class-descriptor
> class="com.jobbank.jobbank.model.offer.OfferVO" table="offer"
> auto-retrieve="true" auto-update="false"
> auto-delete="false">
> <field-descriptor
> name="offerId"
> column="offerid"
> jdbc-type="INTEGER"
> primarykey="true"
> />
> <field-descriptor
> name="name"
> column="name"
> jdbc-type="VARCHAR"
> />
> <field-descriptor
> name="offerPrice"
> column="offerprice"
> jdbc-type="DOUBLE"
> />
> <field-descriptor
> name="offerStarts"
> column="offerstarts"
> jdbc-type="TIMESTAMP"
> />
> <field-descriptor
> name="offerEnds"
> column="offerends"
> jdbc-type="TIMESTAMP"
> />
> <field-descriptor
> name="exposure"
> column="exposure"
> jdbc-type="INTEGER"
> />
> <field-descriptor
> name="url"
> column="url"
> jdbc-type="VARCHAR"
> />
> <field-descriptor
> name="description"
> column="description"
> jdbc-type="VARCHAR"
> />
> <field-descriptor
> name="status->modified"
> column="modified"
> jdbc-type="TIMESTAMP"
> />
> <field-descriptor
> name="status->added"
> column="added"
> jdbc-type="TIMESTAMP"
> />
> <field-descriptor
> name="status->disabled"
> column="disabled"
> jdbc-type="INTEGER"
>
> conversion="org.apache.ojb.broker.accesslayer.conversions.Bo
> olean2IntFieldConversion"
> />
> <collection-descriptor
> name="offeredProducts"
>
> element-class-ref="com.jobbank.jobbank.model.offer.OfferedProductVO"
> proxy="true">
> <inverse-foreignkey field-ref="offerId"/>
> </collection-descriptor>
> </class-descriptor>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------
> ---------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.536 / Virus Database: 331 - Release Date: 03/11/2003
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
