Hello,
I have hibernate 3.3 with oracle 10g
I try do object query. Hibernate generates:
select table1_.NUMBER from table table1_ and I get ORA-01747, because NUMBER is the key work in oracle. I can execute SQL query select table1_."NUMBER" from table table1_ by adding quotas and its ends success. How to configure hibernate to autaomaticly add quotas to column

Thea same problem:
https://forums.hibernate.org/viewtopic. ... 1bee455978

Best regards

Add backticks around the column name in your mapping/annotation. For example:


See http://docs.jboss.org/hibernate/stable/ ... dentifiers

Thanks for replay.
But I cannot understand why in hibernate dialect don't generates this automaticly in his sql query.
Because how I can migrate from Oracle(which use "") to MSSQL(which use {}) now I must correct my all hbm files.

I think that one reason is that the behavior of some databases is different if the names are quoted and if they are not. For example, a database may decide to convert all unquoted names to upper or lower case, which may mean that select * from some_table and select * from "some_table" not are equivalent. It can really be a mess and there is no way for Hibernate to assume that one way is more correct than the other. If you need portability between different databases I think the best bet is to use quoted names. Hibernate will automatically replace the backticks with the correct quote character.