Hibernate schema definition and Oracle public synonym

Make sure that you don't specify schema in Hibernate mappings if you have public synonym defined for tables in Oracle.

Here is the setup. I had a table MY_TABLE mapped in MyTable.hbm.xml. In the database, a public synonym "MyTable" is created for MY_TABLE. I also had two schema definitions in Hiberante. One is the default schema in Spring config.

<br /><bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"><br />...<br /><property name="hibernateProperties"><br /> <props><br /> ...<br /> <prop key="hibernate.default_schema">myschema</prop><br /> </props><br /></property><br /></bean><br />

The second is in MyTable.hbm.xml
<br /><hibernate-mapping><br /><class name="..." schema="myschema" table="MY_TABLE"><br />...<br /></class><br /></hibernate-mapping><br />

At runtime, Hibernate has problem resolving and working on the right table. It worked after schema definitions were removed from both places and left the resolution to Oracle.