i have a column named values which is the preserved word in sql syntax.
when use jdbc, i can handle this by specifying the table name with the values column(tablename.values). but in Hibernate i cannot do this.
does any1 know how to solve this problem? the database shouldn't be changed.
thx very much

You can directly use SQL within Hibernate (SQLQuery or even, if nothing else helps, get the DB connection and work with JDBC), so you should be able to solve your problem.

Shouldn't this hint be helpful, provide your concrete example/code.

Erik

i don't think so. if doing in this way, OR mapping loses its meanning.
for example, i have one table named NUMBER, with two columns inside( id, and values)
when i want to insert a new record, the sql command will be insert into number(id, NUMBER.values) values('1','100')
but in hibernate how can you handle this, when i save one number instance, the generated sql is insert into number(id, values) values('1','100')

thank u very much for help

Would something like

be of any help?

Erik

no, i have tried this before
column="NUMBER.VALUES" makes hibernate throw no column found exception
but anyway, thanks for ur help

look for how to quote sql identifiers in the ref documentation.

hi max, thanks for you help, but i cannot find how to solve this problem from the ref documentation, will you plz show me? thankx very much

Which version of Hibernate are you using? Look in documentation of 3.0.5, chapter 5.3 (was 6.3 in 2.1.6)

Erik