Yep, that fixed it. Thanks much! > -----Original Message----- > From: dandamudi sudhakar [mailto:[EMAIL PROTECTED] > Sent: Friday, July 11, 2003 8:10 PM > To: [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > Reply-To: <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED] Apache. Org" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
