wood burning stoves 2.0*
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
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 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
Similar Threads
Entity EJB CMP question in WSAD
Hibernate check if schema exists
Hibernate: adding underscore to attibute names
Database access through CMP, Setting Schema
Create tables in different database schemas using EJB 3 Entity Persistent