QueryException every time!?

nerotnt · **Joined:** Wed Oct 08, 2003 10:31 am **Posts:** 247

I'm trying to make a query, as shown below:

( ... )
Iterator it = session.find(
"select b.mp_fk, b.qtd_actual " +
"from a in class test.X, " +
"b in class test.Y, " +
"c in class test.Z " +
"where c.mp_lote_fk = a.id and a.mp_fk = b.mp_fk"
);
( ... )

It keeps giving me :

net.sf.hibernate.QueryException: could not resolve property type: mp_lote_fk ...

Am I doing something wrong? Is there another way of doing these type of queries?
How do I acess the information on every "it.next()"?

Please help.

PS: thanks Emmanuel for the tip on lazy.

max · **Posted:** Sun Oct 26, 2003 1:23 pm

you are using property names that looks very much like physical column names. Do you really have a propery called mp_lote_fk - remember to use property names, not column names.

emmanuel · **Posted:** Sun Oct 26, 2003 1:27 pm

do you mean

Code:

Iterator it = session.iterator(

or

Code:

List list = session.find(

From the javadoc of iterate

Quote:

Entities returned as results are initialized on demand. The first SQL query returns
* identifiers only. So <tt>iterate()</tt> is usually a less efficient way to retrieve
* objects than <tt>find()</tt>.

Read section 7.3 of the reference guide.

Can't help you much on your query 'cause I don't have your mapping files, but the error tells me mp_lote_fk is not a mapped property of test.Z. Usually in HQL, you do not need to manipulate fks, it's an object query language, so you manipulate objects and relations between objects

An example of 7.3

Code:

select customer, product from Customer customer, Product product join customer.purchases purchase where product = purchase.product

has nothing to do with fk.

Prefer using from test.X as a or from test.X a than a in class test.X, it's the old way to write HQL.