I have a employee table with following columns:
emp_id,emp_name,dept_code
and a department table with following columns:
dept_code, dept_name

the mapping file fot employee is :
<class name="employee" table="dcm_ipc_t_sess_hdr">
<id name="id" column="emp_id" type="int"/>
<property name="name" column="emp_name"/>
<many-to-one name="dept" fetch="select" column="dept_code" class="department" >

...

on the screen I want to display emp_id,emp_name,dept_code without dept_name, I think only employee table need to be retrieved. but when I catch query the retrieveing of department table also generated as a separate select statement.
How can I avoid this.

Thank you

change in:



fetch="select" to fetch="lazy"

good luck

Shouldn't it be fetch="join" or lazy="true"?

Yes lazy="true" sorry about that this actualy is the default.
How is your query?

Do you mean the one in the other topic? It's working ok, as far as I see.

Sorry not yours but the one from richwin618 he gets the extra select....
The fetch property has nothing to do with the extra select....

Please post the code for the query.

Thanks everyone.

I did changed to fetch ="join". it merged into one single join query.however,what I want is even nojoin becuse in my example,everything I need are emp_id,emp_name,dept_code from employee table, I don't need anything from department table,even I setup relationship in the mapping file.
the generated query is:

Select this_.emp_id As emp1_40_1_, this_.emp_name As emp_n2_40_1_, this_.dept_id As dept3_40_1_, dept2_.dept_id As dept1_24_0_, dept2_.dept_name As dept2_24_0_
From employee this_ Inner Join department dept2_
On this_.dept_id=dept2_.dept_id

the code for the query is very simple:
Criteria crit = emp.createCriteria(Employee.class);
result = crit.list();

I am using Hibernate 3.1

I got it working with the following in the mapping:



Good Luck

i tried fetch="select" lazy="proxy" like:


<class name="employee" table="dcm_ipc_t_sess_hdr">
<id name="id" column="emp_id" type="int"/>
<property name="name" column="emp_name"/>
<many-to-one name="dept" fetch="select" lazy="proxy" column="dept_code" class="department" >

it's still generate query to the department table

by the way, I'm doing this in a multi-tier web application, in the DAO,I'm doing ceritiria.list(), in the JSP ,I try to get and display each element such as id,name,dept_code.the structure like:JSP->EJB->DAO.

is this happened beacuse inside DAO which access database with Hibernate doesn't know what element will be accessed by JSP,that's why it try to get everything include element from department table? until JSP to get element from list,it's to late to realize it is useless to retrieve department table?

if this is true, then the lazy fetch is useless in a multi-tier application

the fetching is so hard to control

I'm so confused about the hibernate fetching

??