I have in repository like this:
<class-descriptor class="net.vettenranta.interfaceForEverything"
proxy="dynamic">
<extent-class class-ref="net.vettenranta.Everything1" />
<extent-class class-ref="net.vettenranta.Everything2" />
<extent-class class-ref="net.vettenranta.Everything3" />
<extent-class class-ref="net.vettenranta.Everything4" />
</class-descriptor>
and then net.vettenranta.Everything1 doesn't have anything special
defined for that Interface. what I read from documentation, it should
use outer left join for those fields automaticly if extent is used.
but it doesn't.
I don't know does it matter, but I'm not retrieving collection, I'm
retrieving Iterator.
- Joose
Joose Vettenranta kirjoitti 19.12.2005 kello 16:31:
Hi,
I'm using interface to get lot's of data from different tables..
But I have a problem.
query.addOrderBy(field);
it orders by result, but per table, not whole result. When looking
at postgresql query log, I see that it is implemented like this:
SELECT ... FROM bar1 orderBy fieldID;
SELECT ... FROM bar2 orderBy fieldID;
SELECT ... FROM bar3 orderBy fieldID;
so, of course it won't sort it right..
wouldn't it work better, if it would generate it like this:
SELECT .. FROM bar1 UNION SELECT .. FROM bar2 UNION SELECT .. FROM
bar2 order by fieldID;
or have I configured it wrong?
- Joose
--
"Always remember that you are unique, just like everyone else!"
* http://iki.fi/joose/ * [EMAIL PROTECTED] * +358 44 561 0270 *
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
"Always remember that you are unique, just like everyone else!"
* http://iki.fi/joose/ * [EMAIL PROTECTED] * +358 44 561 0270 *
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]