[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-5918) generate schema update script does not respect default schema and default catalog when querying foreign key contraints

generate schema update script does not respect default schema and default catalog when querying foreign key contraints ---------------------------------------------------------------------------------------------------------------------- Key: HHH-5918 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5918 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.0 final, 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.0.5, 3.1, 3.1.1, 3.1.2, 3.1.3, 3.2.0.ga, 3.2.1, 3.2.2, 3.2.3, 3.2.4.sp1, 3.2.5, 3.2.6, 3.2.7, 3.3.0.SP1, 3.3.1, 3.3.2, 3.5.0-Final, 3.5.1, 3.5.2, 3.5.3, 3.5.4, 3.5.5, 3.5.6, 3.6.0, 3.6.1 Reporter: Christoph W. Assignee: Gail Badner Priority: Critical Attachments: org.hibernate.cfg.configuration.patch Original Estimate: 0.5h Remaining Estimate: 0.5h When starting session factoring with mode "allow schema update" the database is inspected. Table structures are queried within correct schema and catalog. But foreign key constraints and indexes were not. If a index/foreign key is defined in another schema at the same sql server, the index/foreign key is not created in the current schema. The fix is very easy. org.hibernate.cfg.Configuration (revision 20769), method generateSchemaUpdateScript(Dialect, DatabaseMetadata): In line 1174 und 1175 use default schema und catalog if not specified for the table. This metadata is used for table structures. Copy these 2 lines to 1217 und 1218 where the default schema and catalog is _not_ used when not specified for the table. This metadata is used for foreign key and indexes.