Does hibernate have or support a UNION Funtionality?

queenHibernate · **Joined:** Mon Aug 13, 2007 2:37 am **Posts:** 22

Hi guys,

I'm trying to write a search engine query for a website. So, I'm wondering if Hibernate has a UNION function or something similar to combine query results? Please, I would apprecite any examples you can provide.

Thanks in advance...

cablepuff · **Joined:** Tue Apr 01, 2008 5:39 pm **Posts:** 61

sorry no. Instead please use

option 1.
<sql-query name="someQueryWithUnion">
....
</sql-query>

In your external mappoing.

Or

option 2.

write two name queries and map it to two set.

Than do set1.addAll(set2).

Cameron McKenzie · **Posted:** Sun Jun 08, 2008 10:37 am

Writing tow named queries and mapping it to two sets is how I tyically do this.