Special character in table name hibernate giving error

Question

I am trying to update the table from Hibernate. My table name has the special character '@' at the beginning of the name. When I am trying to update it its giving me following error.

SEVERE: Servlet.service() for servlet [kendo] in context with path [/GanttView] threw exception [Request processing failed; nested exception is org.hibernate.QueryException: unexpected char: '@' [Update [@IS_Demand] set sel=1]] with root cause org.hibernate.QueryException: unexpected char: '@' [Update [@IS_Demand] set sel=1]

I don't want to change the name of the table in the database because then I will have to change many things. Is there any way I could access it. I tried many other combinations like

\"@IS_Demand\"  or  '@IS_Demand' or '[@IS_Demand]'

Anyone knows the answer?

Possible duplicate of http://stackoverflow.com/questions/14932136/make-hibernate-backquote-all-table-column-names — Madushan Perera, Dec 03 '15 at 11:47

score 1 · Answer 1 · answered Dec 03 '15 at 11:43

1

try using the escape charater for the same

\\@IS_Demand

or

!@IS_Demand

answered Dec 03 '15 at 11:43

Vivek Singh

2,047
11
24

score 1 · Answer 2 · answered Dec 03 '15 at 11:49

1

There is a property available you need to set.

<property name="hibernate.globally_quoted_identifiers" value="true"/>

For more details,

AvailableSettings.html#GLOBALLY_QUOTED_IDENTIFIERS

answered Dec 03 '15 at 11:49

Ankur Singhal

26,012
16
82
116

Thank you so much Ankur-singhal i will try using it – mona Dec 03 '15 at 12:07
I tried this just now but its not working. I am using hibernate 4.1.7. – mona Dec 05 '15 at 05:03

score 0 · Answer 3 · answered Dec 03 '15 at 11:43

0

Set the property hibernate.globally_quoted_identifiers=true

answered Dec 03 '15 at 11:43

Si mo

969
9
24

Special character in table name hibernate giving error

3 Answers3

Linked