Hi all,

Hibernate version:
3.2.2

My SQL query


field1 AND field 2 in TABLE2 ARE NOT PRIMARY KEYS !!!

I don't know how to create the mapping file and the Hibernate query for this kind of query ?

Can someone help me please.
Thank you.

I have the exact same problem. Any help would be much appreicated!

Thanks!

Hi there,

Have solved temporarily my problem using createSQLQuery
witch support standard query ... (check hibernate documentation)

String sql = " SELECT ... LEFT OUTER JOIN table2 ... ON ... WHERE"

SQLQuery q = getSession().createSQLQuery(sql);
q.addScalar("retva1", Hibernate.INTEGER);
q.addScalar("retval2", Hibernate.INTEGER);
q.addScalar("retdate", Hibernate.CALENDAR);

List list = q.list();

for (Iterator iter = list.iterator(); iter.hasNext();) {
Object[] element = (Object[]) iter.next();
...

Thanks, I have certainly considered dropping back to SQL, was just hoping I could keep all my queries in HQL.