Hi,
Schema validator throws the following exception whenever the given table is a synonym:
Code:
org.hibernate.HibernateException: Missing table: MyTable
The reason for this is that when checking if a table exists, Hibernate's DatabaseMetadata only queries the following table types:
Code:
private static final String[] TYPES = {"TABLE", "VIEW"};
However, JDBC's DatabaseMetaData also defines types like "SYNONYM" and "ALIAS":
Code:
Typical types are "TABLE", "VIEW", "SYSTEM TABLE",
"GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
Is it possible to use the validator with synonyms? If not, can I create a JIRA issue for this?
Cheers,
Peter
Login
FAQ
Search