[Reactor For CF] clustered key support?

[Dave Shuck]

I have to preface this by saying that I have absolutely no control over the structure of this database.  It is a horrendous design that some client server apps talk to and I am hoping to access with Reactor/ColdFusion.  If the naming were the only problem, that would be bad enough but the relationships are just silly.  None of the tables in the database have any kind of distinct PK field.  They are all clustered keys made up of wonderful fieldnames like "REFERENCE_ID" [varchar],"COMPANY_CODE"[varchar], and "BORROW_ID"[int].  Once I determine whether I can even use Reactor for this, I will deal with the aliasing, but for now I want to just keep it straight forward to see if this is even possible. Now that I have hopefully cleared my name to some extent, here is my issue.  Given the following abbreviated structure....

table: LOAN_BORROWER
REFERENCE_ID
COMPANY_CODE
BORROW_ID (which is just a number 1 to however many borrowers there are for this company/referenceId)

REO (stands for real estate owned.... obviously.... )
REFERENCE_ID
COMPANY_CODE
BORROW_ID
REO_ID ( [int] that actually makes the REO record distinct )

Is it even possibly to use Reactor to make a hasMany relationship of REOs as children to LOAN_BORROWER?
I tried this without success:

        <object name="LOAN_BORROWER">
            <hasMany name="REO">
                <relate from="REFERENCE_ID" to="REFERENCE_ID" />
                <relate from="COMPANY_CODE" to="COMPANY_CODE" />
                <relate from="BORROW_ID" to="BORROW_ID" />               
            </hasMany>           
        </object>

I have even tried this:
        <object name="LOAN_BORROWER">
            <hasMany name="REO">
                <relate from="REFERENCE_ID,COMPANY_CODE,BORROW_ID" to="REFERENCE_ID,COMPANY_CODE,BORROW_ID" />
            </hasMany>           
        </object>

Neither one of these give any kind of error when I dump a LOAN_BORROWER record.  They just don't include properties/methods related to anything beyond the LOAN_BORROWER.

Can someone tell me if what I am hoping to achieve is even possible?
--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com
www.worldwildweb.biz -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/