Hello I have a cocoon version number 2.0.3, a tomcat version number 4.1.12, a j2sdk1.4.0_02 and an Oracle 8i database
I have a store procedure in my database called validar and it is in a package. The name of the package is JBDPL. I tested the store procedure and it doesn't have any problem. It has 3 parameters. The first and the second are in parameters, and must be String. The third is an out parameter and must be integer. The name of the page is validar.xsp The source of this page is <?xml version="1.0" encoding="ISO-8859-1"?> <xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2" xmlns:xsp-request="http://apache.org/xsp/request/2.0" > <page> <title></title> <content> <esql:connection> <esql:pool>sgcWebXML_oracle_pool</esql:pool> <esql:execute-query> <esql:call> { CALL JBDPL.validar ( <esql:parameter direction="in" type="String"><xsp-request:get-parameter name="funcionariotextfield"/></esql:parameter> ,<esql:parameter direction="in" type="String">Oracle</esql:parameter> ,<esql:parameter direction="out" type="Int"></esql:parameter> ) } </esql:call> </esql:execute-query> </esql:connection> </content> </page> </xsp:page> In the sitemap I have <map:match pattern="validar.xsp"> <map:generate type="serverpages" src="validar.xsp"/> <map:serialize type="xml"/> </map:match> When I tried to load the page I have the next problem Cocoon 2 - Internal server error ------------------------------------------------------------------------------- - type fatal message Exception in ServerPagesGenerator.generate() description org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.NullPointerException sender org.apache.cocoon.servlet.CocoonServlet source Cocoon servlet stack-trace org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.NullPointerException at org.apache.cocoon.generation.ServerPagesGenerator.generate (ServerPagesGenerator.java:270) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process (CachingEventPipeline.java:250) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process (CachingStreamPipeline.java:399) at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.matchN4000B2 (C:\Archivos de programa\Apache Group\Tomcat 4.1 \work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:1037) at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:484) at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:397) at org.apache.cocoon.sitemap.Handler.process(Handler.java:224) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) at org.apache.cocoon.www.sitemap_xmap.matchN4002C9(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www\sitemap_xmap.java:3337) at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www\sitemap_xmap.java:2579) at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www\sitemap_xmap.java:2516) at org.apache.cocoon.sitemap.Handler.process(Handler.java:224) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) at org.apache.cocoon.sitemap.SitemapManager.process (SitemapManager.java:154) at org.apache.cocoon.Cocoon.process(Cocoon.java:575) at org.apache.cocoon.servlet.CocoonServlet.service (CocoonServlet.java:999) 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.invokeNe xt(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.invokeNe xt(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.invokeNe xt(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(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.invokeNe xt(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.processConnecti on(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) Caused by: java.lang.NullPointerException at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:270) at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray (TTCAdapter.java:256) at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet (TTCAdapter.java:231) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1437) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch (TTC7Protocol.java:887) at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:1959) at oracle.jdbc.driver.OracleStatement.doExecuteOther (OracleStatement.java:1879) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout (OracleStatement.java:2489) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate (OraclePreparedStatement.java:435) at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:500) at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute (EsqlQuery.java:362) at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute (EsqlQuery.java:336) at org.apache.cocoon.www.SGCWebXML.logical.validar.validar_xsp.generate (C:\Archivos de programa\Apache Group\Tomcat 4.1 \work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML/logical/validar\validar_xsp.java:423) at org.apache.cocoon.generation.ServerPagesGenerator.generate (ServerPagesGenerator.java:258) ... 45 more java.lang.NullPointerException at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:270) at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray (TTCAdapter.java:256) at oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet (TTCAdapter.java:231) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1437) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch (TTC7Protocol.java:887) at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:1959) at oracle.jdbc.driver.OracleStatement.doExecuteOther (OracleStatement.java:1879) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout (OracleStatement.java:2489) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate (OraclePreparedStatement.java:435) at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:500) at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute (EsqlQuery.java:362) at org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute (EsqlQuery.java:336) at org.apache.cocoon.www.SGCWebXML.logical.validar.validar_xsp.generate (C:\Archivos de programa\Apache Group\Tomcat 4.1 \work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML/logical/validar\validar_xsp.java:423) at org.apache.cocoon.generation.ServerPagesGenerator.generate (ServerPagesGenerator.java:258) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process (CachingEventPipeline.java:250) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process (CachingStreamPipeline.java:399) at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.matchN4000B2 (C:\Archivos de programa\Apache Group\Tomcat 4.1 \work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:1037) at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:484) at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:397) at org.apache.cocoon.sitemap.Handler.process(Handler.java:224) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) at org.apache.cocoon.www.sitemap_xmap.matchN4002C9(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www\sitemap_xmap.java:3337) at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www\sitemap_xmap.java:2579) at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de programa\Apache Group\Tomcat 4.1\work\Standalone\localhost\cocoon\cocoon- files\org/apache/cocoon/www\sitemap_xmap.java:2516) at org.apache.cocoon.sitemap.Handler.process(Handler.java:224) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) at org.apache.cocoon.sitemap.SitemapManager.process (SitemapManager.java:154) at org.apache.cocoon.Cocoon.process(Cocoon.java:575) at org.apache.cocoon.servlet.CocoonServlet.service (CocoonServlet.java:999) 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.invokeNe xt(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.invokeNe xt(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.invokeNe xt(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke (ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNe xt(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.invokeNe xt(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.processConnecti on(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) request-uri /cocoon/SGCWebXML/logical/validar/validar.xsp path-info SGCWebXML/logical/validar/validar.xsp ------------------------------------------------------------------------------- - Please help me!!!! Saul Zarrate Cardenas --------------------------------------------------------------------- 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]>