I am using hibernate.reveng.xml to generate pojos for 2 tables that i have that are located in 2 different schemas.

Table1 - schema1
Table2 - schema2

Table2 doesnt have a foreign key referencing Table1. but there is an implicit relationship...so i want the proxy object and association created in the pojos..

To accomplish the above, i added the following entry in reveng.xml

<table name="Table2" schema="schema2"
<primary-key>
---------
</primary-key>
<foreign-key constraint-name="Table2_FK"
foreign-schema="schema1"
foreign-table="Table1">

<column-ref local-column="Test1_ID" foreign-column="ID"/>
<many-to-one property="TestExt" exclude="false"/>
<set property="Tests"/>
</foreign-key>
</table>

Moreover, i dont want the generated hbm files to have refernce to Schema name... So, i added default_schema property in hibernate.cfg.xml file

After the code generation, i could nt see the proxy object and association generated as part of the pojo. (i dont see the HashSet and proxy object)

But if i remove default_schema property from hibernate.cfg.xml, and generate the code, i do see the association and proxy...
then again, this doesnt solve my purpose, because this adds the schema name in hbm.xml file

Max/Anyone, can you help resolve this?

Thanks

can someone help me on this

if the hbm.xml won't have schema listed for at least one of these tables how is hibernate going to find the table(s) that are not in the default schema ?