db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Clotworthy" <tclotwor...@bka-inc.com>
Subject Only 10 columns exist!
Date Fri, 11 Jul 2003 19:43:43 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message