This is probably really a websphere question, but I wonder if anyone has similar experience and has solved it.

When I use Hibernate with a DB2/400 data source in Websphere, and set the property on the session factory to auto-create the tables, they are all created in the default library QGPL.

Does anyone know how to stop that and ensure they are created in the library I want? Either by correct configuration of the websphere datasource, or an option in hibernate (e.g. to qualify all unqualified table names with <MYLIBRARY.>)

Hibernate version:
2.1.6
Mapping documents:
n/a
Code between sessionFactory.openSession() and session.close():
n/a
Full stack trace of any exception that occurs:
n/a
Name and version of the database you are using:
DB2/400 V5R2M0
Debug level Hibernate log excerpt:

grep "schema" in the user manual (there are multiple ways)