I give up for the night. BTW I am using Release Candidate 2. Not sure it matters, but I am using PersistentFieldClass=org.apache.ojb.broker.metadata.fieldaccess.PersistentNestedFieldMaxPerformanceImpl so that I could use '->' Single Table Aggregation as it wasn't implemented in the default implementation.
>From the archives it seemed ok to map multiple primary keys to one primary key. ----- Original Message ----- From: [EMAIL PROTECTED] Date: Friday, October 31, 2003 2:49 am Subject: Re: Another silly newbie mapping question > Still no luck. I noticed that my primary key order might have > something to do with it so I switched the order within the > OrderItemVO mapping, but it didn't seem to help. I realized that > based on the logging that OJB does not seem to even be trying to > materialize the OfferVO object as no notice is printed about it > trying. Here is my logging: > > > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: > executeQuery : Query from class > com.jobbank.jobbank.model.order.OrderItemVO where > [EMAIL PROTECTED] DEBUG: SQL:SELECT > A0.modified,A0.offerid,A0.disabled,A0.mid,A0.offerq > uantity,A0.orderid,A0.buylater,A0.added FROM orderitem A0 WHERE > (mid = ? ) AND orderid = ? > [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: > executeQuery: [EMAIL PROTECTED]: SELECT > A0.modified,A0.offerid,A0.disabled,A0.mid,A0.offerquantity,A0.orderid,A0.buylater,A0.added > FROM orderitem A0 WHERE (mid = 2 ) AND orderid = 0 > [org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> > true[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: > hasNext() -> false > [org.apache.ojb.broker.core.PersistenceBrokerImpl] DEBUG: PB.close > was called: [EMAIL PROTECTED] > 8 > TEST CartItem: [2|0|1|1|false|[2003-10-31 02:50:11.515|2003-10-31 > 02:50:11.515|false]|]WITH OFFER: null > TEST: After ShoppingCartActions.populateMemberShoppingCart() > > > > > > > ----- Original Message ----- > From: [EMAIL PROTECTED] > Date: Friday, October 31, 2003 1:56 am > Subject: Another silly newbie mapping question > > > > > I have worked out much harder mapping problems then this, but > for > > some reason I am still a bit new on this stuff and making no > > headway. I would appreciate a more seasoned glance. > > > > Problem: OfferVO is not being materialized after succesfully > > retrieving the Collection of OrderItemVO by using > > getCollectionByQuery(query). Each OrderItemVO should have > exactly > > one OfferVO, but the reference to the OfferVO only returns null. > > > > > > > > <!-- Definitions for the OrderItemVO object --> > > <class-descriptor > > class="com.jobbank.jobbank.model.order.OrderItemVO" > table="orderitem">> <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="offerId" > > column="offerid" > > jdbc-type="INTEGER" > > primarykey="true" > > /> > > <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 --> > > <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" > > /> > > <collection-descriptor > > name="offeredProducts" > > element-class- > > ref="com.jobbank.jobbank.model.offer.OfferedProductVO" > > > proxy="true"> <inverse-foreignkey field-ref="offerId"/> > > </collection-descriptor> > > </class-descriptor> > > > > > > Thank you muchly, > > > > JohnE > > > > > > > > ----------------------------------------------------------------- > -- > > -- > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
