[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1785) validate not working with oracle dblinks

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1785?page=c... ] Ben Turner commented on HHH-1785: --------------------------------- I use Oracle database links with Public Synonyms, and have a related problem. My table, lets call it DATA@OTHERDB is owned by DB_OWNER. So we have setup a view to the table called DATA_V, again owned by DB_OWNER, that points at the table. Then finally we have a public synonym pointing DATA at DB_OWNER.DATA_V However, I get trouble when using Chris Richardson's ORMUnit ( http://ormunit.googlecode.com) which sets up a Hibernate Configuration object then calls configuration.generateSchemaUpdateScript(dialect, dbmd) which it then would go on to parse the output for missing / extra items. This call fails with the following in the logs: 2008-01-18 12:00:13,714 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: DB_OWNER.LOCAL_TABLE 2008-01-18 12:00:13,714 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [id, column1, other_column] 2008-01-18 12:00:13,714 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: [...] 2008-01-18 12:00:13,714 [main] INFO org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [...] 2008-01-18 12:00:13,729 [main] INFO org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: DATA So I am guessing the schema update script is presuming the table is local and not over a database link. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira