cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Felix Kugel" <F.Ku...@gmx.de>
Subject Tutorial application error
Date Fri, 08 Mar 2002 09:06:49 GMT
In the Cocoon tutorial application, I created a few departments. Then,
as I tried to add an employee to one of the departments, Cocoon produced
the following error message:

-------------------------- Cocoon error message
Message: 
   Could not add record

Source:  
   org.apache.cocoon.ProcessingException

Description: 
   org.apache.cocoon.ProcessingException: Could not add record:
java.sql.SQLException: Column not found: EMPLOYEE in statement [INSERT
INTO employee (id, employee, department_id) VALUES (6, 'Felix', 4)]
-------------------------- 

My Configuration:
Windows XP
Tomcat 4.0.1
Cocoon 2.0.1 (Binary distribution)

Thanks for any help,
Felix




Stack Traces:

Original exception : java.sql.SQLException: Column not found: EMPLOYEE
in statement [INSERT INTO employee (id, employee, department_id) VALUES
(6, 'Felix', 4)] at org.hsqldb.Trace.getError(Trace.java:180) at
org.hsqldb.Result.<init>(Result.java:175) at
org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907) at
org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718) at
org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686) at
org.hsqldb.jdbcStatement.execute(jdbcStatement.java:354) at
org.hsqldb.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:688)
at
org.apache.cocoon.acting.DatabaseAddAction.processTable(DatabaseAddActio
n.java:179) at
org.apache.cocoon.acting.DatabaseAddAction.act(DatabaseAddAction.java:73
) at
org.apache.cocoon.www.tutorial.sitemap_xmap.action_set_process(sitemap_x
map.java:547) at
org.apache.cocoon.www.tutorial.sitemap_xmap.matchN100BC(sitemap_xmap.jav
a:1137) at
org.apache.cocoon.www.tutorial.sitemap_xmap.process(sitemap_xmap.java:74
8) at
org.apache.cocoon.www.tutorial.sitemap_xmap.process(sitemap_xmap.java:67
0) at org.apache.cocoon.sitemap.Handler.process(Handler.java:180) at
org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127) at
org.apache.cocoon.www.sitemap_xmap.matchN102DF(sitemap_xmap.java:3653)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2632) at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2426) at
org.apache.cocoon.sitemap.Handler.process(Handler.java:180) at
org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127) at
org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144
) at org.apache.cocoon.Cocoon.process(Cocoon.java:582) at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:795)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:243) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:201) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
4) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:164) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:170) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462
) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:163) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
ava:1011) at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:
1106) at java.lang.Thread.run(Thread.java:484)  


 org.apache.cocoon.ProcessingException: Could not add record:
java.sql.SQLException: Column not found: EMPLOYEE in statement [INSERT
INTO employee (id, employee, department_id) VALUES (6, 'Felix', 4)] at
org.apache.cocoon.acting.DatabaseAddAction.act(DatabaseAddAction.java:86
) at
org.apache.cocoon.www.tutorial.sitemap_xmap.action_set_process(sitemap_x
map.java:547) at
org.apache.cocoon.www.tutorial.sitemap_xmap.matchN100BC(sitemap_xmap.jav
a:1137) at
org.apache.cocoon.www.tutorial.sitemap_xmap.process(sitemap_xmap.java:74
8) at
org.apache.cocoon.www.tutorial.sitemap_xmap.process(sitemap_xmap.java:67
0) at org.apache.cocoon.sitemap.Handler.process(Handler.java:180) at
org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127) at
org.apache.cocoon.www.sitemap_xmap.matchN102DF(sitemap_xmap.java:3653)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2632) at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2426) at
org.apache.cocoon.sitemap.Handler.process(Handler.java:180) at
org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127) at
org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144
) at org.apache.cocoon.Cocoon.process(Cocoon.java:582) at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:795)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:243) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:201) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
4) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:164) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:170) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462
) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:163) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
ava:1011) at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:
1106) at java.lang.Thread.run(Thread.java:484) java.sql.SQLException:
Column not found: EMPLOYEE in statement [INSERT INTO employee (id,
employee, department_id) VALUES (6, 'Felix', 4)] at
org.hsqldb.Trace.getError(Trace.java:180) at
org.hsqldb.Result.<init>(Result.java:175) at
org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907) at
org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718) at
org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686) at
org.hsqldb.jdbcStatement.execute(jdbcStatement.java:354) at
org.hsqldb.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:688)
at
org.apache.cocoon.acting.DatabaseAddAction.processTable(DatabaseAddActio
n.java:179) at
org.apache.cocoon.acting.DatabaseAddAction.act(DatabaseAddAction.java:73
) at
org.apache.cocoon.www.tutorial.sitemap_xmap.action_set_process(sitemap_x
map.java:547) at
org.apache.cocoon.www.tutorial.sitemap_xmap.matchN100BC(sitemap_xmap.jav
a:1137) at
org.apache.cocoon.www.tutorial.sitemap_xmap.process(sitemap_xmap.java:74
8) at
org.apache.cocoon.www.tutorial.sitemap_xmap.process(sitemap_xmap.java:67
0) at org.apache.cocoon.sitemap.Handler.process(Handler.java:180) at
org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127) at
org.apache.cocoon.www.sitemap_xmap.matchN102DF(sitemap_xmap.java:3653)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2632) at
org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2426) at
org.apache.cocoon.sitemap.Handler.process(Handler.java:180) at
org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127) at
org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144
) at org.apache.cocoon.Cocoon.process(Cocoon.java:582) at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:795)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193) at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:243) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:201) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:234
4) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:164) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:170) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:170) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462
) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:564) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:163) at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.ja
va:566) at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
72) at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.j
ava:1011) at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:
1106) at java.lang.Thread.run(Thread.java:484)  


 java.sql.SQLException: Column not found: EMPLOYEE in statement [INSERT
INTO employee (id, employee, department_id) VALUES (6, 'Felix', 4)] 


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message