Is there any way to get hibernate to generate case sensitive SQL for Oracle? My existing tables and column names are case sensitive, and are named exactly the same as the object that accesses them. I was hoping there was some switch, or simple code change that would enable hibernate to automatically generate the right case for the name.

Would subclassing the oracle dialect in some way help?


Hibernate version: 3.2.2 GA
Annotations version: 3.2.1
Java version: 1.6.0
Jboss version: 4.0.5 GA
Name and version of the database you are using: Oracle 9i (9.2.0.7.0)

As far as I recall you just have to enclose the table- and column-names in your mappings in backticks, e.g.

column="`CaseSensitiveName`"

Yeah, i remember reading something about that. But I was hoping to get away without having any mapping (by using annotations and accepting the default mapping).

It's not a big deal I guess, but it would be convenient since the names are identical to the DB names.