Hello again,
I got the following exception from an otherwise ordinary query:
[2003-07-11 15:36:58,983][fes][FATAL][Thread-5][support.FESSupportDAO] -
[FESSup
portDAO.selectAddress] - selectAddress() cannot be completed|
com.workingdogs.village.DataSetException: Only 10 columns exist!
at com.workingdogs.village.Record.getValue(Unknown Source)
at
com.hotapp.fes.om.BaseRefOrgPeer.populateObject(BaseRefOrgPeer.java:3
21)
at
com.hotapp.fes.om.BaseRefOrgPeer.row2Object(BaseRefOrgPeer.java:279)
at
com.hotapp.fes.om.BaseRefOrgPeer.populateObjects(BaseRefOrgPeer.java:
427)
at
com.hotapp.fes.om.BaseRefOrgPeer.doSelect(BaseRefOrgPeer.java:339)
at
com.hotapp.fes.support.FESSupportDAO.selectAddress(FESSupportDAO.java..
etc, etc..
The exact query, as created by torque works perfectly fine when I run it
directly against the Oracle database:
SELECT DISTINCT
REF_ADDRESS_USAGE.DODAAC_CODE,
REF_ORG.ORG_CODE,
REF_ORG.ORG_NAME,
REF_ORG.CIC_CODE,
REF_DODAAC.DESCRIPTION,
REF_ADDRESS.POC_NAME,
REF_ADDRESS.TELEPHONE,
REF_ADDRESS.DSN_PREFIX,
REF_ADDRESS_USAGE.ADDRESS_TYPE,
REF_ADDRESS_USAGE.PROCESS_NAME
FROM
REF_ADDRESS_USAGE,
REF_ORG,
REF_DODAAC,
REF_ADDRESS
WHERE
REF_ORG.DODAAC_CODE=REF_DODAAC.DODAAC_CODE AND
REF_ORG.DODAAC_CODE=REF_ADDRESS_USAGE.DODAAC_CODE AND
REF_ORG.ORG_CODE=REF_ADDRESS_USAGE.ORG_CODE AND
REF_ORG.ORG_TYPE=REF_ADDRESS_USAGE.ORG_TYPE AND
REF_ORG.ORG_KIND=REF_ADDRESS_USAGE.ORG_KIND AND
REF_ADDRESS_USAGE.ADDRESS_ID=REF_ADDRESS.ADDRESS_ID
Why is this ok with Oracle, but not Torque? Thanks for any ideas.
