Hi,
I have two tables, one table (LOOK_UP) has two columns -a key column and a description column. The second table(CL_INFO) has the key column from the first table as foreign-key.

LOOK_UP table
INSURED_UID number(10)
INSURED_NAME varchar2(50)

CL_INFO table
....
....
INSURED_UID number(10)
....
....


I've modelled this as a many-to-one relationship in the mapping file corresponding to the CL_INFO table, the mapping looks like this-

<many-to-one name="insuredUid" column="INSURED_UID" class="LookUpRow"/>

When I execute a hibernate find query on the CL_INFO table from a stand-alone java program and try to retrieve the description column, it works fine and I'm able to get the description.
But when I execute the same query in a multi-tiered environment, the description is not fetched.

I have two questions-
-is the many-to-one mapping the right choice for this situation and
-why is it that no description is retrieved in a multi-tiered environment.

Thanks in advance.[/list]

Hi,
Looking through the log file, I notice that sql query is generated only for the CL_INFO table, no query was generated for fetching from the LOOK_UP table.

What could this point to?

-Thanks.

Give more info (mapping etc)

Located the problem.
I was saving the data elsewhere before the fetch. During the save an instance of the LookUp data is loaded with only the key (the description is not loaded). And that half loaded data is used in the fetch.

Fixed this by loading the data afresh from the database before the save.

-Thanks