Hibernate version: 2.1.3

Mapping documents: hibernate.hbm.xml

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: DB2 V7.2

Debug level Hibernate log excerpt:

The error message saying: ...jdbc.DB2Exception: ..."DB2ADMIN.ORDER" is an undefined name. SQLSTATE=42704
........

The schema name needs to be but was not used, and the user name (DB2ADMIN) was used, instead.
How should the schema name is defined in mapping file, in addition to table, columns, etc...?

Any help is greatly appreciated.

search for the following keywords, this page http://www.hibernate.org/hib_docs/reference/en/html/session-configuration.html
hibernate.default_schema
hibernate.connection.url
hibernate.connection.datasource

schema should be set in the datasource settings or in hibernate.connection.url.