[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1697?page=c... ] Vlad Skarzhevskyy commented on HHH-1697: ---------------------------------------- I had the same problem. Our production database connection looks to synonyms of tables and sequences. My solution was to Extend the Oracle9Dialect class and set hibernate.dialect in config. In hibernate.cfg.xml hibernate.dialect=myapp.persistence.Oracle9fixedDialect And the java file package myapp.persistence; import org.hibernate.dialect.Oracle9Dialect; /** * Fix the problem with hibernate.hbm2ddl.auto=validate * When connecting to read only schema. */ public class Oracle9fixedDialect extends Oracle9Dialect { public Oracle9fixedDialect() { super(); } public String getQuerySequencesString() { return "select sequence_name from user_sequences " + "union " + "select synonym_name from user_synonyms us " + "where exists (select 1 from all_objects ao where object_type='SEQUENCE' and " + "us.table_name = ao.object_name)"; } } -- 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