This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes How to set Schema name in hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "How to set Schema name in hibernate" Watch "How to set Schema name in hibernate" New topic
Author

How to set Schema name in hibernate

tom yan
Greenhorn

Joined: Aug 10, 2004
Posts: 1
I'm having difficulty figuring out a message when running hibernate-based application. It says ...jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.ORDER" is an undefined name. SQLSTATE=42704.

Evidently, the schema name (supposed to be "trial_1") was not used, and user name was used instead. Therefore, the question becomes How I can set up the schema name when doing mapping in hibernate, specifically, in hibernate.hbm.xml, or other places?

Any help would be greatly appreciated!
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You can include the schema name in the Properties you configure your SessionFactory with. How you configure those properties its up to you - wether programatically, through hibernate.properties or another config file. The examples I think use hibernate.properties - in which case your schema name is defined in your hibernate.connection.url (you'll have to refer to DB2 docs to check the syntax). Alternatively, if you are running Hibernate for use in a container, you define the schema name where you define the DataSource.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to set Schema name in hibernate