Multiple Criterias?

andresgr · **Posted:** Mon Nov 27, 2006 1:16 pm

Use createSQLQuery() instead of createQuery()

jbosseur · **Posted:** Mon Nov 27, 2006 1:20 pm

Hi, please always post your mapping files or java files.

with hql assuming your represented all your tables as pojos
the hql would become something like this:

Code:

SELECT p.produktnavn, k.knavn FROM Produkt p 
JOIN p.produktkategoris pk
JOIN pk.kategori k
JOIN p.produktfarges pf
JOIN pf.farge f
where k.id = '1164113247767' 
and p.pris between 0 and 5000 
and f.id = '1164113248104'

Good luck

cash1981 · **Joined:** Mon Sep 04, 2006 7:18 am **Posts:** 45

jobosser: I think what he ment is how do you transfer this sql code to pure Hibernate code. I believe he has Pojos classes already.

I would have helped if I knew how to :-)

jbosseur · **Posted:** Tue Nov 28, 2006 6:53 am

I thought the question was a bit vague because he was also talking about criterias... but if he wants to execute the sql as it is just use createSQLQuery

take a look at : Native Sql queries

good luck