So, I iterated through the Collection of orderItems I had retrieved and extracted the offers attached by each manually and it worked.
I guess I am to the point where I don't know why the getCollectionByQuery() won't pull automagically each Offer. Manual means work, but are very inefficient and I want to understand this just for the sake of understanding. JohnE ----- Original Message ----- From: [EMAIL PROTECTED] Date: Sunday, November 2, 2003 5:24 pm Subject: Re: RE: Another silly newbie mapping question > Still no clue on what is wrong with this. > > > > > ----- Original Message ----- > From: [EMAIL PROTECTED] > Date: Friday, October 31, 2003 3:19 pm > Subject: Re: RE: Another silly newbie mapping question > > > Thank you Robert, but Offers are permanent pieces of information > > in the database whereas OrderItems come and go. > > > > > > The site holds numerous Offers which are stored permanently in > the > > database. The customer has a shopping cart which is basically > an > > OrderItem based on those Offers. So when I get an OrderItem > from > > the database I just wanted to also be able to pull the > associated > > Offer though I would never want Offer to change. > > > > I have looked in the ojb's repository_junit.xml test cases which > > have always helped me in the past, but i think I am just missing > > something. The Collection of OrderItems pull, but not these > > attached Offer objects. I have verified the database, etc. > The > > messages don't seem to show it even attempting to pull the Offer. > > > > I have a similar reference for Member and Location that is > working > > so it is confusing to me. Thank you for any ideas as I am about > > plum out of them. > > > > JohnE > > > > > > > > > > > > > > > > ----- Original Message ----- > > From: Robert J Celestino <[EMAIL PROTECTED]> > > Date: Friday, October 31, 2003 10:11 am > > Subject: RE: Another silly newbie mapping question > > > > > Hello John, > > > > > > I think you want auto-update="true" instead of "false" here: > > > > > > > > > <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> > > > > > > my thinking is that when you store the OrderItem the Offer is > > not > > > writen bacause auto-update is false. Then when reading the > > > OrderItem back out, the Offer is not there. > > > > > > Bob c > > > > > > > > > --------------------------------------------------------------- > - > > > Bob Celestino > > > SAS Research and Development > > > 919 - 531 - 9425 > > > [EMAIL PROTECTED] > > > > > > SAS - The Power to Know > > > > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] [EMAIL PROTECTED] > > > > Sent: Friday, October 31, 2003 5:01 AM > > > > To: OJB Users List > > > > Subject: Re: Another silly newbie mapping question > > > > > > > > > > > > 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.fieldacc > > > > ess.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] > > > > oker.accesslayer.sql.SqlGeneratorDefaultImpl] 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,A > > > > 0.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: ojb-user- > [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] > > > > > > > > > > > > > > --------------------------------------------------------------- > -- > > -- > > > -- > > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
