I am using Oracle 10g and with Jboss 3.0.8, hibernate3.0.jar and ojdbc14.jar. Also I am using Oracle9Dialect.
I hav a table in Oracle which has "level" as one of the column name. I have mapped this table in hibernate. But the problem is when hibernate generates select query for this table it does not enclose the level column in double quotes (") and hence the query fails when Oracle database tries to execute the query generated by hibernate. Since level is a keyword in Oracle, it needs to be enclosed in double quotes when it is used in query but hibernate doesn't seem to do that.
My problem is i can't change the column name to anything other than level since it is used in some place in my application. I don't know hoe to tackle this...need help.

Tried escaping the names in the mapping document (section 5.4 in the manual)?

Nik,
Thanks for such a prompt reply. It worked!