If I understand the problem correctly, this has been corrected in the current CVS by a patch I supplied in October. Please try your case with the current CVS and see if this fixes it. If not, if you could supply a small test case that would be helpful.
see src/test/org/apache/ojb/broker/ConvertedKeyReferenceTest.java for the previously fixed condition. Russell On Thu, 2002-11-28 at 01:39, Mahler Thomas wrote: > seems to be a bug > > > -----Ursprüngliche Nachricht----- > > Von: Corey Klaasmeyer [mailto:[EMAIL PROTECTED]] > > Gesendet: Dienstag, 26. November 2002 22:43 > > An: 'OJB Users List' > > Betreff: [ForeignKeys] 0.9.7 FieldConversions with... > > > > > > I have a number of 1:1 relationships with the FieldConvesions > > specified in > > the foreign-key descriptors. Conversions do not seem to be > > performed on the > > foreign-key. Is there a way to make this happen? > > > > Corey > > > > -----Original Message----- > > From: Yuriy Zubarev [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, November 26, 2002 3:26 PM > > To: [EMAIL PROTECTED] > > Subject: 1:1 queries are not optimized > > > > > > Hello everyone, > > > > Let's say I have 2 object: Company and Contact. Contact has > > attribute 'company' of type Company as a look up value. > > (in database it's two table 'companies' and 'contacts' where > > the latter has foreign key to the former) > > > > Now I need to show list of contacts with company name for > > each contact. In repository.xml class-descriptor for Contact > > has reference-descriptor pointing to Company (typical 1:1 > > mapping). When contact list gets displayed with 10 rows, > > OJB (PB) executes 11 queries: 1 - to get contact and then 10 > > to get Company info for every contact. > > > > 11 queries with this simple case (in real situation it's much more) > > is just not acceptable. > > > > Is there a way for OJB to issue only one query to get all information? > > > > Any hint is greatly appreciated! > > > > Yuriy Zubarev > > > > > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > > http://mailplus.yahoo.com > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
