You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Travis Stevens <Tr...@noaa.gov> on 2003/01/07 21:39:56 UTC
Only 2 columns exist!
Hello,
I'm getting an error that says "Only 2 columns exist!". This is talking
about a result from a query that village is making on a particular
table. The table has 3 columns ( I swear!). The db-schema.xml db
config file is also defined as having 3 columns. I'm looking into this,
but if anyone has come accross this before, please let me know.
-Trav
Error:
root cause
com.workingdogs.village.DataSetException: Only 2 columns exist! at
com.workingdogs.village.Record.getValue(Unknown Source) at
gov.globe.tg.torque.BaseEducationAreaPeer.populateObject(BaseEducationAreaPeer.java:287)
at
gov.globe.tg.torque.BaseEducationAreaPeer.row2Object(BaseEducationAreaPeer.java:253)
at
gov.globe.tg.torque.BaseEducationAreaPeer.populateObjects(BaseEducationAreaPeer.java:393)
at
gov.globe.tg.torque.BaseEducationAreaPeer.doSelect(BaseEducationAreaPeer.java:305)
at
org.apache.jsp.conceptsearch$jsp._jspService(conceptsearch$jsp.java:88)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet$JspServletWrapper.service(IDEJspServlet.java:173)
at
org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.serviceJspFile(IDEJspServlet.java:246)
at
org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.service(IDEJspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:536) rethrown as
org.apache.torque.TorqueException: Only 2 columns exist! at
gov.globe.tg.torque.BaseEducationAreaPeer.populateObject(BaseEducationAreaPeer.java:291)
at
gov.globe.tg.torque.BaseEducationAreaPeer.row2Object(BaseEducationAreaPeer.java:253)
at
gov.globe.tg.torque.BaseEducationAreaPeer.populateObjects(BaseEducationAreaPeer.java:393)
at
gov.globe.tg.torque.BaseEducationAreaPeer.doSelect(BaseEducationAreaPeer.java:305)
at
org.apache.jsp.conceptsearch$jsp._jspService(conceptsearch$jsp.java:88)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet$JspServletWrapper.service(IDEJspServlet.java:173)
at
org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.serviceJspFile(IDEJspServlet.java:246)
at
org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.service(IDEJspServlet.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:536) Caused by:
com.workingdogs.village.DataSetException: Only 2 columns exist! at
com.workingdogs.village.Record.getValue(Unknown Source) at
gov.globe.tg.torque.BaseEducationAreaPeer.populateObject(BaseEducationAreaPeer.java:287)
... 40 more
------------------------------------------------------------------------
.....
Re: Only 2 columns exist!
Posted by Gareth Boden <ga...@egsgroup.com>.
Yeah.. the reason is cos doSelect() will call
Criteria.addSelectColumn() to add all the columns for your object to
the Criteria. It should probably treat Criteria as effectively
immutable and clone it..
G.
On Wednesday, January 8, 2003, at 12:41 am, Henning P. Schmiedehausen
wrote:
> "Travis Stevens" <Tr...@noaa.gov> writes:
>
>> FYI,
>
>> to answer my own question,
>
>> wrong:
>> Criteria crit = new Criteria();
>> List aList = APeer.doSelect(crit);
>> List bList = BPeer.doSelect(crit);
>
>
>> right:
>> Criteria crit = new Criteria();
>> List aList = APeer.doSelect(crit);
>> crit = new Criteria();
>> List bList = BPeer.doSelect(crit);
>
> Ugh. Thats' IMHO a bug.
>
> Regards
> Henning
>
> --
> Dipl.-Inf. (Univ.) Henning P. Schmiedehausen -- Geschaeftsfuehrer
> INTERMETA - Gesellschaft fuer Mehrwertdienste mbH hps@intermeta.de
>
> Am Schwabachgrund 22 Fon.: 09131 / 50654-0 info@intermeta.de
> D-91054 Buckenhof Fax.: 09131 / 50654-20
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
---
Development Team Leader, eGS, 5-7 Singer Street, London EC2A 4BQ. +44
(0)20 7336 1440
CONFIDENTIALITY: This is email is confidential and intended solely for
the use of the individual to whom it is addressed. Any views or
opinions presented are solely those of the author and do not
necessarily represent those of eGovernment Solutions (UK) Ltd. If you
are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, or copying
of this email is strictly prohibited. If you have received this email
in error please contact the sender.
Re: Only 2 columns exist!
Posted by "Henning P. Schmiedehausen" <hp...@intermeta.de>.
"Travis Stevens" <Tr...@noaa.gov> writes:
>FYI,
>to answer my own question,
>wrong:
>Criteria crit = new Criteria();
>List aList = APeer.doSelect(crit);
>List bList = BPeer.doSelect(crit);
>right:
>Criteria crit = new Criteria();
>List aList = APeer.doSelect(crit);
>crit = new Criteria();
>List bList = BPeer.doSelect(crit);
Ugh. Thats' IMHO a bug.
Regards
Henning
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen -- Geschaeftsfuehrer
INTERMETA - Gesellschaft fuer Mehrwertdienste mbH hps@intermeta.de
Am Schwabachgrund 22 Fon.: 09131 / 50654-0 info@intermeta.de
D-91054 Buckenhof Fax.: 09131 / 50654-20
Re: Only 2 columns exist!
Posted by Travis Stevens <Tr...@noaa.gov>.
FYI,
to answer my own question,
wrong:
Criteria crit = new Criteria();
List aList = APeer.doSelect(crit);
List bList = BPeer.doSelect(crit);
right:
Criteria crit = new Criteria();
List aList = APeer.doSelect(crit);
crit = new Criteria();
List bList = BPeer.doSelect(crit);
-Trav
Travis Stevens wrote:
> Hello,
>
> I'm getting an error that says "Only 2 columns exist!". This is
> talking about a result from a query that village is making on a
> particular table. The table has 3 columns ( I swear!). The
> db-schema.xml db config file is also defined as having 3 columns. I'm
> looking into this, but if anyone has come accross this before, please
> let me know.
>
> -Trav
>
> Error:
>
> root cause
>
> com.workingdogs.village.DataSetException: Only 2 columns exist! at
> com.workingdogs.village.Record.getValue(Unknown Source) at
> gov.globe.tg.torque.BaseEducationAreaPeer.populateObject(BaseEducationAreaPeer.java:287)
> at
> gov.globe.tg.torque.BaseEducationAreaPeer.row2Object(BaseEducationAreaPeer.java:253)
> at
> gov.globe.tg.torque.BaseEducationAreaPeer.populateObjects(BaseEducationAreaPeer.java:393)
> at
> gov.globe.tg.torque.BaseEducationAreaPeer.doSelect(BaseEducationAreaPeer.java:305)
> at
> org.apache.jsp.conceptsearch$jsp._jspService(conceptsearch$jsp.java:88)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet$JspServletWrapper.service(IDEJspServlet.java:173)
> at
> org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.serviceJspFile(IDEJspServlet.java:246)
> at
> org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.service(IDEJspServlet.java:339)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
> at java.lang.Thread.run(Thread.java:536) rethrown as
> org.apache.torque.TorqueException: Only 2 columns exist! at
> gov.globe.tg.torque.BaseEducationAreaPeer.populateObject(BaseEducationAreaPeer.java:291)
> at
> gov.globe.tg.torque.BaseEducationAreaPeer.row2Object(BaseEducationAreaPeer.java:253)
> at
> gov.globe.tg.torque.BaseEducationAreaPeer.populateObjects(BaseEducationAreaPeer.java:393)
> at
> gov.globe.tg.torque.BaseEducationAreaPeer.doSelect(BaseEducationAreaPeer.java:305)
> at
> org.apache.jsp.conceptsearch$jsp._jspService(conceptsearch$jsp.java:88)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet$JspServletWrapper.service(IDEJspServlet.java:173)
> at
> org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.serviceJspFile(IDEJspServlet.java:246)
> at
> org.netbeans.modules.tomcat.tomcat40.runtime.IDEJspServlet.service(IDEJspServlet.java:339)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
> at
> org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
> at
> org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
> at
> org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
> at java.lang.Thread.run(Thread.java:536) Caused by:
> com.workingdogs.village.DataSetException: Only 2 columns exist! at
> com.workingdogs.village.Record.getValue(Unknown Source) at
> gov.globe.tg.torque.BaseEducationAreaPeer.populateObject(BaseEducationAreaPeer.java:287)
> ... 40 more
> ------------------------------------------------------------------------
>
> .....
>
>
>