|
Hi, I've following mapping:
<class name="com.Order.OrderStore"
identity="order_sno" key-generator="SEQUENCE">
<map-to table="order_tbl"/> <field name="contract_no" type="string"> <sql name="contract_no"/> </field> <field name="stage" type="com.ezan.contract.StageStore"> <sql name="stage_no"/> </field> <field name="order_sno" type="integer"> <sql name="order_sno"/> </field> <field name="o_name"
type="string">
<sql name="o_name"/> </field> </class> <class name="com.ezan.contract.StageStore" identity="stage_no" depends="com.ezan.contract.ContractStore"> <map-to table="stages_tbl"/> <field name="contract_no" type="com.ezan.contract.ContractStore"> <sql name="contract_no"/> </field> <field name="stage_no" type="integer"> <sql name="stage_no"/> </field> <field name="s_name" type="string"> <sql name="s_name"/> </field> <field name="order" type="com.Order.OrderStore"> <sql name="order_sno"/> </field> </class> Tables defined as:
stage_table( order_sno)->order_table( order_sno) and
order_table(contract_no,stage_no)-> stage_table( contract_no,stage_no)
but when I try to load OrderStore I've got:
java.sql.SQLException: ORA-01416: two tables cannot be outer-joined
to each other
What could be wrong?
Thanx.
|
