Hibernate basic question

Thread view:

vk02720 - 17 Jun 2006 14:23 GMT

Hi,

Using Hibernate, I want to get the output of a complex query and map
the resulting columns my application class. How can I do that ?

For example
select a.x, b.x, b.y from a, b where a.id = b.id and b.x in ( select x
from c ) ....

I just need to map the three elements from the query result to my app
class.

Appreciate any help.

TIA

Reply to this Message

Markus Volkland - 19 Jun 2006 17:17 GMT

... like this?

session.createQuery("select new your.package.YourAppClass(a.x, b.x, b.y)
from AEntity a, BEntity b where a.id = b.id and b.x in ( select x
from c ) ....");

where YourAppClass is like

class YourAppClass {
    private String _ax;
    private String _bx;
    private String _by;

    public YourAppClass (String ax, String bx, String by) {
        _ax = ax;
        _bx = bx;
        _by = by
    }

    // getters and setters
    ...
}

hope this helps,

Markus

vk02720 schrieb:

> Hi,
>
[quoted text clipped - 11 lines]
>
> TIA

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...