Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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 The Software Craftsman this week in the Agile 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

How to set Schema name in hibernate

tom yan

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

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 or another config file. The examples I think use - 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
Have you tried LearnNowOnline?
subject: How to set Schema name in hibernate