foreign keys... again

[Robert S. Sfeir]

Still a bit confused, If I have this:

<class-descriptor class="net.sfeir.business.RequestBO" table="REQUESTS">
<field-descriptor name="assignedToID" column="assignedTo" jdbc-type="INTEGER"/>
...

and I want to setup a foreign key from assignedToID to another table called Users and the column there is called userID
I added this as the foreign-key reference:

<reference-descriptor name="userBO" class-ref="net.sfeir.security.business.UserBO">
<foreignkey field-ref="userID"/>
</reference-descriptor>

But it doesn't make any sense, if I put assignedToID in the field-ref, how does it know the column I am mapping? If I put the userID like I did in the field-ref how does it know that I am mapping assignedToID? You can't always expect the table column names to match, most of the time they won't.

I'm missing something here that would let me tell the descriptiptor. The RequestBO object has a getter and setter which get back a UserBO as suggested earlier, but even if it does a getUserBO() and it gets the UserBO back, UserBO doesn't have a method called getAssignedTOID() nor do I want to do that because that's breaking the OO rules of the framework.

I'm totally confused right now and unfortunately, the docs are not very clear.


R

--
Robert S. Sfeir
Senior Java Engineer
National Institutes of Health
Center for Information Technology
Department of Enterprise Custom Applications
[EMAIL PROTECTED]


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