Hibernate version:
3.3.1GA
Mapping documents:
Too large to show here
Code between sessionFactory.openSession() and session.close():
Name and version of the database you are using:
AS400 iSeries
My question relates to getting Hibernate to quote the lowercase table and column names in all generated SQL. I am using Teneo to generate the hbm.xml for me. I know I can add about 4500 annotations to my model to get it to use table="`blah`" and similar for column name, but that is tedious in the extreme. Is there a way to blanket way set this?
Also Is there a way to get Hibernate to do this "SET SCHEMA BLAH"? either that or add the SCHEMA name to all generated SQL.
So this
Code:
SELECT inst.id FROM instancetbl inst
becomes this
Code:
SELECT inst."id" FROM SCHEMANAME."instancetbl" inst
thx.
David
Code: