|
Hi,
also exact same issue here. We are using Hibernate 4.3.6.Final, with Spring 4.1.4.RELEASE, on Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production, JPA 2.1 api. We have two schemas in one datasource. I have annotated the Entity correctly:
@Table(name = "APP_CHECK", schema = "APS_OTHER_DEV")
I also reference the same schema in @SequenceGenerator, but the sql generated by Hibernate has no schema in it. select APP_CHECK_SEQ_ID.nextval from dual.. gives ORA-00942: table or view does not exist
I'm not in a position to introduce the use of EntityManager.
regards John
|