I am using hibernate against a database with columns defined in mixed case. There are two names available for columns. One is a mixed case name and the other is a short upper-case name. The columns are created like: "insertDate" FOR COLUMN insdat DATE. The map and class generator needed some tweaking to work with the mixed names but it wasn't that far off. Mostly I had to prevent the lower-caseing of column names and added a single quote (') around the column and table name attributes.

Are there any landmines associated with using mixed case names?

Thanks

Your database is case sensitive toward column names? Wow...

Which one is that? (so I can stay away from it ;)

Well that answers that... I thought most databases were case sensitive when dealing with quoted names. The database in this case is DB2, but I have seen the same thing with Oracle. MySQL seems to be case agnostic. It depends on how the table is created.

In this case, I do have the option of using the short name, which is all uppercase but it is not the value returned by the meta classes so the generation is won't work without some massaging.

Off topic a bit but I was using the Unify Database for a client for many years and it is case sensative. It was a pain at times.