Number is first char in column name leads to error (MSSQL)

squishy · **Joined:** Wed Apr 12, 2006 4:10 am **Posts:** 2

Hello,
I have to use an old and big database in my application and it is best if i don't change anything like column names and stuff.
Problem is, someone named a column "4_a_prinzip". Now if hibernate queries that table i get the following error:

Code:

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect syntax near '.4'.

in order to make it work the column name would have to be surrounded by []
ie

Code:

select * from foo where foo.[4_a_prinzip] = 1

is there a way to tell hibernate to do so?

thanks in advance

pepelnm · **Posted:** Wed Apr 12, 2006 4:48 am

How did you map that column in the .hbm.xml files?

maybe if you do:
column="[4_a_prinzip]"

squishy · **Joined:** Wed Apr 12, 2006 4:10 am **Posts:** 2

hmm i'm not using hibernate directly, but jboss ejb3. maybe better to ask there? :)

MjH · **Posted:** Wed Apr 12, 2006 12:08 pm

I understand you don't want to change the existing database objects, but can you create a view? If so, you could create a view that maps the table in question but changes the names of the offending columns. You could then use the view as the 'table' in your Hibernate code.