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 RE: Only 10 columns exist!
Date Sat, 12 Jul 2003 13:00:36 GMT
Yep, that fixed it. Thanks much!

> -----Original Message-----
> From: dandamudi sudhakar [mailto:dandamudisudhakar@hotmail.com]
> Sent: Friday, July 11, 2003 8:10 PM
> To: tclotworthy@bka-inc.com
> Subject: Re: Only 10 columns exist!
> 
> when the query is executed, torque will try to load the corresponding
> objects. So select all the required columns ( i.e specified as
required in
> the schema), then it will work.
> I had the same problem. I could solve selecting all the required
columns
> from the table.
> 
> 
> 
> 
> Sudhakar Dandamudi
> 4 Lamont ave, Apt#6
> Hamilton,NJ 08619
> ph. home:6095846968
>     cell:6465288826
> 
> 
> 
> 
> 
> ----Original Message Follows----
> From: "Tim Clotworthy" <tclotworthy@bka-inc.com>
> Reply-To: <tclotworthy@bka-inc.com>
> To: "Torque-User@Db. Apache. Org" <torque-user@db.apache.org>
> Subject: Only 10 columns exist!
> Date: Fri, 11 Jul 2003 15:43:43 -0400
> 
> 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.
> 
> _________________________________________________________________
> The new MSN 8: smart spam protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message