reference-descriptors

[Robert S. Sfeir]

I want to test foreign keys in OJB, I have 3 class descriptor examples below, and I would like to know if in the last descriptor I've successfully mapped the homeID and brokerID of the BROKERS_TO_HOMES table to the HOMES homeID and BROKERS brokerID.


<class-descriptor class="net.sfeir.business.HomeBO" table="HOMES">
<field-descriptor id="1" name="homeID" column="homeID" jdbc-type="INTEGER" autoincrement="true" primarykey="true" nullable="false"/>
...
</class-descriptor>

<class-descriptor class="net.sfeir.business.BrokersBO" table="BROKERS">
<field-descriptor id="1" name="brokerID" column="brokerID" jdbc-type="INTEGER" autoincrement="true" primarykey="true" nullable="false"/>
...
</class-descriptor>

<class-descriptor class="com.lawton.business.BrokersToHomes" table="BROKERS_TO_HOMES">
<field-descriptor id="1" name="recordID" column="recordID" jdbc-type="INTEGER" primarykey="true" autoincrement="true" />
<field-descriptor id="2" name="bBrokerID" column="brokerID" jdbc-type="INTEGER" nullable="false" />
<field-descriptor id="3" name="bHomeID" column="homeID" jdbc-type="INTEGER" nullable="false" />
<reference-descriptor name="homeID" class-ref="com.lawton.business.HomeBO">
<foreignkey field-id-ref="bHomeID"/>
</reference-descriptor>
<reference-descriptor name="brokerID" class-ref="com.lawton.business.BrokerBO">
<foreignkey field-id-ref="bBrokerID"/>
</reference-descriptor>
</class-descriptor>

Thanks
R


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]