Hi All,
In my application , while executing HSQL i m getting this error "Invalid Identifier" as "DEPARTMENT"

Sub part of Query is,
from User where
and department in(select deptId from Department where lower(deptName) like lower('"+department.getDeptName().trim()+"%'))"

In Business object of User,
department object is a "Has a part".

Mapping part is,
<many-to-one name="Department" column="dept_no" unique="false"
class="com.greenlight.testxpert.persistence.Department"
cascade="none" not-null="false"
foreign-key="FK_USR_DEPT" />

dept_no is foriegn key of department table.

Please help me to solve this problem.

from,
Gajendra

Hi Gajendra,

are you trying to execute SQL or HQL?

And how exactly are you calling it? Can you please post your code?

Furthermore, before posting it would help if you read this.

Regards,
Frank

hi frank,

Problem has been solved...
By changing mapping information,
There i have changed the column name, which is primary key of another table. I use same name in my current table i.e. foreign key "gdm_id"

<many-to-one name="Department" column="gdm_id" unique="false"
class="com.greenlight.testxpert.persistence.Department"
cascade="none" not-null="false"
foreign-key="FK_USR_DEPT" />

Is it a hibernate rule for foreign key to use same name as primary key?

Regards,
Gajendra