I'm new to Hibernate and i'm trying to save a new object
into the database (DB2) per session.save(obj);

i have to use the schema "ADLER" (the table is called "ADLER.VORGANG"),
the userid is db2inst1.

When selecting objects from the database and updating these objects, everything works fine.
BUT when i create a new object and try to save it, i get an sql-exception that tells me : '"DB2INST1.VORGANG" is an undefined name'.

it seems to me, that only for insert-statements the userid is used instead of "ADLER" as schema name. all the other statements work fine.

Similar problem occured for the user of this thread:
http://forum.hibernate.org/viewtopic.php?t=933449
but the given solution doesn't work for me. I have placed the "schema" attribute into the "class" tag of the mapping file and i'm using the "hibernate.default_schema" property within the hibernate configuration file.

thx for help.
bastian

howdy,
finally i found the solution to my problem within this forum:

http://forum.hibernate.org/viewtopic.php?t=930484&highlight=schema+generator
Topic: generator doesen't respect schema of table

this bug seems to be known, but they won't fix 'em. too bad!

the generator doesn't respect the schema of your table and this way the userid is used as schema name instead.

this way it works:

Provide a patch or buy support hours if you need to get it fixed immediately.