Hello,

I don't know how to do this query with hibernate:

select userid,username,'S' where userid in
(
select userid from usermap where usermap.userrole = 2
)
union
select userid,username,'N' where userid NOT in
(
select userid from usermap where usermap.userrole = 2
)

Can't use constant in select so 'S' can't be returned by HQL

Ok,

Now, is it impossible to do this query with hibernate? Is it possible with hibernate 2.1?

A lot of thanks,

Marcial

Hibernate does not support unions. Use two queries.

Is very difficult to work with hibernate if I can't make unions and declare constants.

Another solution is to make 2 querys, and with java add the constants. It's not beautiful, but it works.

Is there another solution with hibernate?

A lot of thanks,

Marcial

You must remember that Hibernate is a O/R mapping and provide APIs for the Object side of the O/R mapping.
IMO it's very relational to talk to constants and unions, since you don't use object request but flat select paramters.