Hi, please help me :) I am getting the following error:
Description: org.apache.cocoon.ProcessingException: Could not add record: java.sql.SQLException: ERROR: ExecAppend: Fail to add null value in not null attribute cli_id The parameter is set at the beginning of the page using: <parameter name="cli_id"><xsp:attribute name="value"><xsp-request:get-parameter name="cli_id"/></xsp:attribute></parameter> Also I see the parameter in the generated HTML: <input value="1" name="cli_id" type="hidden"> I think that it means the parameter is setted good, but I am getting the error. Also the FormValidator is working good. It passes the verification: <parameter name="cli_id" nullable="no" type="long"/> In the sitemap the process is with: <map:match type="request-parameter" pattern="cocoon-action-Create"> <map:act action="crear" type="form-validator"> <map:parameter name="descriptor" value="docs/{../1}-form.xml"/> <map:parameter name="validate-set" value="add"/> <map:act type="dbAdd"> <map:parameter name="descriptor" value="docs/{../../1}-form.xml"/> <map:parameter name="validate-set" value="add"/> <map:generate src="docs/{../../../1}-confirm.xsp" type="serverpages"/> <map:transform src="stylesheets/agssa.xsl"/> <map:serialize/> </map:act> </map:act> </map:match> And in the sitemap.log i found: WARN (2002-10-07) 19:32.27:839 [sitemap] (/multipremios/can-crear.html) Thread-5/ExcaliburComponentManager: ComponentLocator exception from parent CM during lookup. org.apache.avalon.framework.component.ComponentException: Could not find component at org.apache.avalon.excalibur.component.ExcaliburComponentManager.lookup(ExcaliburComponentManager.java:255) at org.apache.cocoon.components.CocoonComponentManager.lookup(CocoonComponentManager.java:236) at org.apache.avalon.excalibur.component.DefaultComponentFactory$ComponentManagerProxy.lookup(DefaultComponentFactory.java:393) at org.apache.avalon.excalibur.component.ExcaliburComponentManager.lookup(ExcaliburComponentManager.java:185) at org.apache.cocoon.components.CocoonComponentManager.lookup(CocoonComponentManager.java:236) at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invokeErrorHandler(PipelineNode.java:198) at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:175) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:107) at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:150) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:326) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:308) at org.apache.cocoon.Cocoon.process(Cocoon.java:595) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1034) 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:260) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533) at java.lang.Thread.run(Thread.java:536) DEBUG (2002-10-07) 19:32.27:842 [sitemap] (/multipremios/can-crear.html) Thread-5/ExcaliburComponentManager: Could not find ComponentHandler, attempting to create one for role [org.apache.cocoon.components.notification.NotifyingBuilder] DEBUG (2002-10-07) 19:32.27:845 [sitemap] (/multipremios/can-crear.html) Thread-5/DefaultComponentHandler: ComponentHandler initialized for: org.apache.cocoon.components.notification.DefaultNotifyingBuilder DEBUG (2002-10-07) 19:32.27:847 [sitemap] (/multipremios/can-crear.html) Thread-5/DefaultComponentFactory: ComponentFactory creating new instance of org.apache.cocoon.components.notification.DefaultNotifyingBuilder. DEBUG (2002-10-07) 19:32.27:859 [sitemap] (/multipremios/can-crear.html) Thread-5/DefaultComponentFactory: ComponentFactory decommissioning instance of org.apache.cocoon.components.notification.DefaultNotifyingBuilder. What I am doing wrong? Thanks in advance, Antonio Gallardo. --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>