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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
