this is a known problem.
ojb executes two queries (one for each extent) an thus cannot sort the results of the two queries correctly.
a solution could be to use sql UNION , but afaik this is not supported by all dbms.
jakob
Thomas Cornet wrote:
Hello
I have a sort problem on a query. I have 2 subclasses (AA and AB) which inherits from a superclass (A). Where I'm executing a query on the superclass A to get AA and AB instances, that's working fine, but if I specify a sort parameter, then I have a collection with at the top all the sorted instance of AA then all the sorted instance of AB (like 'A', 'B', 'C', 'D', 'A', 'B', 'C', 'D').
So OJB sorts subclass by subclass, and I need to re-sort the entire collection to have a global sort. Is there any way to avoid this problem ?
Thomas
--------------------------------------------------------------------- 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]
