Specifying Owner ID for DB2 in Hibernate

hibernater · **Joined:** Mon Nov 22, 2004 5:01 pm **Posts:** 2

Hi,

I am trying to use Hibernate with DB2. DB2 tables have a owner id prefix.
where do you specify the owner ID?

hibernater · **Joined:** Mon Nov 22, 2004 5:01 pm **Posts:** 2

I prefixed the owner ID in front of the table name in .hbm.xml file in hibernate mapping. It works. Is this the only way? Iam sure there must be a better way than this.

Sylvie · **Joined:** Mon Dec 06, 2004 4:52 am **Posts:** 5

Hi,

use the following in your hibernate.properties:

## specify a default schema for unqualified tablenames
hibernate.default_schema username

max · **Posted:** Mon Dec 06, 2004 8:50 am

this can also be specified in the hbm.xml if you uses tables from multiple schemas.