Hi, I am using ojb1.0_rc4, ODMG api with OJB queries and mysql4. I will describe my problem with an example for you to better understand it. 1) I have a class called ClassA, another class called ClassB and another class called ClassC. 2) ClassA has a collection of ClassB objects which has a reference to a ClassC object. So, ClassA is 1:N associated with ClassB. ClassB is N:1 associated with ClassC. 3) ClassB has a field called _startTime. ClassC has also a field called _startTime. So, both classes have a field with the same name. 4) I use the following collection-descriptor for ClassA in my repository_user.xml file: <class-descriptor class="ClassA" table="class_a"> ..... <collection-descriptor name="_classBObjects" element-class-ref="ClassB" orderby="_classCObject._startTime" sort="ASC" > <inverse-foreignkey field-id-ref="2"/> </collection-descriptor> .... </class-descriptor> 5) The problem is that when I load a ClassA object, the _classBObjects list is populated with ClassB objects which have wrong values for the _startTime field. The values in ClassB._startTime objects are actually values from classC._startTime objects. This is wrong! 6) After some investigation I found out that this happens because of the orderby attribute in collection-descriptor. When I change the orderby element from orderby="_classCObject._startTime" to orderby="_id" the problem disappears.
I believe this is a bug in OJB. Please, does anyone know how to solve this problem? Thanks for your help. Sincerely, Jair Jr