Hi,

I'm facing below problem when using Hibernate with SQL server database. We have an existing application in oracle and we are extending the application database to include the SQL server compatibility as well. One of the tables is named as PLAN. Since PLAN is a key word in SQL server, am getting below error.

Schema Name : CODES
Table Name : PLAN

11:56:43,624 INFO [STDOUT] Hibernate: select this_.PLAN_CODE as PLAN1_8_0_, this_.PLAN_DESC as PLAN2_8_0_, this_.ACTIVE as ACTIVE8_0_ from CODES.PLAN this_
java.sql.SQLException: Incorrect syntax near the keyword 'PLAN'.

If its an inline query then i could sorround the table name with [] and make it work. But since its a hibernate call am not sure how to resolve this. The problem is i cant change the table name as its already in production with oracle. I need to resolve this asap.

Any help is highly appreaciated...

- Halel

In your mapping/annotation declaration, put backticks around the table name: <class table="`PLAN`" ..>. Hibernate should automatically convert the backticks to something that works in your database.

Thanks nordborg ! it worked :-)