I have searched the net ample number of times but could not find anything on it.
The tables mentioned by me are unrelated to each other. They don't have pk/fk relationship
<many-to-one name="departmentId" column="departmentId" not-null="true" />
Now, my question is that how do i retrieve the values from the list? The list would be having joined values from both the tables, employee and department.
Also, suppose i want to join the two tables in such a way that i keep the type of field departmentId in employee class as int only then what modifications should i bring in the mapping file?
Then should i also not change the table employee? what should be the type of the column "departmentId" of table employee??
I mean to say that departmentId column in employee table is having type int though in the class employee i have changed the type of property departmentId to department. Isn't it an error?
But when i try to get the departmentId of table employee by using the following statement:
i get some garbage values. Why is it so?