How to set Schema name in hibernate

[tom yan]

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]

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.