We have run into a really interesting issue with our use of Castor. It shows up when querying objects. We have a mapping (in part) as follows:
Company has a 0-to-many rel with a location Company has a 0-to-many rel with employees Both employee and location have a reference to their "owning" company. When I query on companies such that more than one company would be returned, the following occurrs: For the first company returned by the query, both the collection of employees and collection of locations contain the correct number of entries for the given company. However, all subsequent companies returned by the query contain their locations/employees plus those of the previous company. Here is some sample output to illustrate: ************************************************* Id : 1 Name : Vignette Corporation Employees : 1289 Locations : 0 ************************************************* ************************************************* Id : 4 Name : Test Company 4 Employees : 1289 Locations : 4 ************************************************* ************************************************* Id : 5 Name : Test Company 5 Employees : 1289 Locations : 5 ************************************************* ************************************************* Id : 6 Name : Test Company 6 Employees : 1290 Locations : 12 ************************************************* The counts for company id=1 is correct (it really does have 1289 employees and 0 locations). The counts for company id=4 are incorrect (it really has 0 employees and 4 locations). The counts for company id=5 are incorrect (it really has 0 employees and 1 locations). The counts for company id=6 are incorrect (it really has 1 employees and 7 locations). Does anyone have any idea what could be causing this? And more importantly, how to correct? ******************************************** Steve Ebersole IT Integration Engineer Vignette Corporation 512.741.4195 Visit http://www.vignette.com ******************************************** ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
