[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    Re: feature or a bug?
From:       Joose Vettenranta <joose () iki ! fi>
Date:       2005-12-19 14:42:01
Message-ID: 4EF6064F-B609-40CE-99F8-5D07D1EDCD2E () iki ! fi
[Download RAW message or body]

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/ * joose@iki.fi * +358 44 561 0270 *
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>

--
"Always remember that you are unique, just like everyone else!"
* http://iki.fi/joose/ * joose@iki.fi * +358 44 561 0270 *


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]