problem with case sensitive database

wohlgemuth · **Posted:** Tue May 11, 2004 12:16 pm

dear all I using hibernate 2.1 and a sapdb database with tablenames like this:

myTABLE

now some users want to acces this tables with hibernate, this tool rocks!, and I become the exception:

table MYTABLE not found,

sure thats clear, the name is myTABLE

how can I deal with this?

what's not possible:

- rename all tables and column!
- define some views who wrappes this names to uppercase

thanks gert

michael · **Posted:** Tue May 11, 2004 12:55 pm

Try quoting the table names in the mapping.

wohlgemuth · **Posted:** Tue May 11, 2004 12:59 pm

how?

I use xdoclet and try \"name\", but i don't works...

michael · **Posted:** Tue May 11, 2004 1:00 pm

Try without xdoclet first.

wohlgemuth · **Posted:** Tue May 11, 2004 1:00 pm

ok I test this, whitch quote must i use?

michael · **Posted:** Tue May 11, 2004 1:02 pm

Don't know, why don't you just try it.

wohlgemuth · **Posted:** Tue May 11, 2004 1:07 pm

sure but id dont know the quote for an " " " in xml...

christian · **Posted:** Tue May 11, 2004 3:39 pm

Use backticks.

wohlgemuth · **Posted:** Wed May 12, 2004 2:21 am

sorry don't work...

shl · **Posted:** Wed May 12, 2004 2:59 am

gert,

read this 5.3. SQL quoted identifiers http://www.hibernate.org/hib_docs/reference/en/html/mapping.html#mapping-quotedidentifiers

Leonid

wohlgemuth · **Posted:** Wed May 12, 2004 3:16 am

whitch quoute do you mean?

SHIFT #

or

SHIFT

shl · **Posted:** Wed May 12, 2004 3:30 am

wohlgemuth wrote:

whitch quoute do you mean?

SHIFT #

or

SHIFT

wohlgemuth · **Posted:** Wed May 12, 2004 3:35 am

why are some solutions so simple, copy and paste...

wohlgemuth · **Posted:** Wed May 12, 2004 3:48 am

and now it works...
yeah baby yeah

shl · **Posted:** Wed May 12, 2004 3:50 am

wohlgemuth wrote:

and now it works...
yeah baby yeah

I think it wokrs because you used magic button "Ё" :)