db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Travis Stevens" <Travis.Stev...@noaa.gov>
Subject Re: Only 2 columns exist!
Date Tue, 07 Jan 2003 22:27:03 GMT
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
> ------------------------------------------------------------------------
>
> .....
>
>
>



Mime
View raw message