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: [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]
