JPA Entiy on synonym instead of table

I have a Seam 2.2 based Java EE 5 web application with a bunch of tables mapped to JPA 1.0 Entities via Hibernate 3.3.3. During development it's running on a Tomcat 6, Oracle 10 XE and Windows 7.

Now, we had the request by operations department to split the data model into one schema being the owner of all database objects (myschema) and one schema acting as the application's database user (myschema_app). So I did the following:

create schema myschema_app
grant object rights on all necessary tables from myschema (both regular ones and n:m intermediate tables) and sequences depending on the usage (one or more of select, insert, update, delete) to myschema_app
declare private synonyms in myschema_app in order to use the same names than before and hiding the other schema's name prefix
change property hibernate.default_schema to new schema name in persistence.xml
change user/password in Tomcat's datasource definition in context.xml

When I start the application while having hibernate.hbm2ddl.autoset to validate, I get an exception when the framework tries to create the EntityManagerFactory telling me that a table is missing. When I execute a select statement directly in an sql tool with myschema_app connected, everything works fine.

I understood that using a synonym going on another table is transparent for the application. Has anyone an idea what I may have overlooked?

回答1:

My guess is that hbm2ddl seaches specifically for tables, and not for synonyms, but that your application should indeed work as if the tables existed in the schema. Try to remove the hbm2ddl option and test your application.

EDIT: it seems my guess is true: https://forum.hibernate.org/viewtopic.php?p=2438033

回答2:

As of 4.3.0, It is possible to set hibernate.synonyms=true to solve your problem with synonyms.

References:

https://github.com/hibernate/hibernate-orm/commit/1df4b2ea3c98c74f3b6bbd42e266ee5c7ad60d27

https://hibernate.atlassian.net/browse/HHH-8183

https://github.com/hibernate/hibernate-orm/pull/508