Hello,

I am using oracle synonym with hibernate. I have set up database meta data properties hibernate.hbm2ddl.auto=validate.

Synonym is specified as
@Entity
@Table(name = "S_Foo", schema = "Foo_Schema")
I am getting following error:

org.hibernate.HibernateException: Missing table: S_Foo

Does anybody encounter similiar issue?

It seems that org.hibernate.tool.hbm2ddl.DatabaseMetadata class only allows type TABLE and VIEW.

Does anybody found solution to use sysnonym with hibernate?

Remove the following line from your configuration at all:

I am aware of this workaround. But we skip schema validation.

The problem is in hibernates org.hibernate.tool.hbm2ddl.DatabaseMetadata class where the table types are hardcoded to

private static final String[] TYPES = {"TABLE", "VIEW"}; where it really should be

private static final String[] TYPES = {"TABLE", "VIEW", "ALIAS", "SYNONYM"};

Does anybody try this and patch hibernate?

You can patch Hibernate yourself. It is open source product.

Why do you need schema validation at all? In most cases it will just eat time and resource giving no real gain.