-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: AS400 DB2 quoting lowercase table and column names
PostPosted: Wed Feb 18, 2009 7:25 am 
Newbie

Joined: Wed Jan 28, 2009 12:00 pm
Posts: 12
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:


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
cron
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.