Hibernate version: 3.2.4.sp1

Name and version of the database you are using: DB2 UDB for AS/400 iSeries V5R4m0

The generated SQL: alter table DB.Customer add constraint FK26568AABFFF088A foreign key (division_id) references DB1.Division

Error: [SQL5051] Qualifier DB1 not the same as name DB.

These two tables are created successfully by the automatic SQL, however the commands to create the constraints error out. Both tables have annotations to override the default library:



To successfully create this constraint, the name needs to be preceeded by the database library name, ie DB.FK26568AABFFF088A.

The database connection string provides a default, which is set to DB1. The constraint name, without the preceeding library name, is defaulting back to DB1, causing the error. The table and the constraint must exist in the same library, or SQL5051 is thrown.

I've run into the same issue even with 3.2.6.GA so I created a custom dialect that just minimally extends the existing one. I couldn't figure out how to get the schema for the current table other than pulling it out of the table's name, so that's what I've done. Hope this helps.

Thank you, much appreciated.

This approach only works for tables which reference another table in the same library, because the constraint belongs in the referencing table's library, not the library of the referenced table...

I haven't yet looked into how to access the information about the table doing the referencing within the dialect object.

You're right, but I don't see a way, from a Dialect, to get more information about the table we're working with. Rather than passing specific strings to these dialect functions it would be much more useful if a more complete reference was available (like the referenced and referencing Table objects in this case).

I've followed the calling chain in a number of directions and don't see anything obvious for getting to them. It would be nice if any Dialect experts chimed in here.