Even though I've defined a default schema in my cfg.xml, it seems I still need to specify the schema name for sequences.
Code:
<hibernate-configuration>
<session-factory name="hibernate.session-factory.Oracle">
<!-- properties -->
<property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>
<property name="connection.datasource">ObjectLibDS</property>
<property name="jndi.class">weblogic.jndi.WLInitialContextFactory</property>
<property name="jndi.url">t3://127.0.0.1:7001</property>
<property name="default_schema">eousr</property>
<!-- mapping files -->
<mapping jar="Oracle.hbm.jar"/>
</session-factory>
</hibernate-configuration>
This works:
Code:
<id name="id" type="java.lang.Long">
<column name="TARIFF_ID"/>
<generator class="sequence">
<param name="sequence">eousr.tariff_seq</param>
</generator>
</id>
This doesn't:
Code:
<id name="id" type="java.lang.Long">
<column name="TARIFF_ID"/>
<generator class="sequence">
<param name="sequence">tariff_seq</param>
</generator>
</id>
Is this intentional? Do I have something misconfigured?