Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 12802 invoked by uid 500); 24 Nov 2002 01:56:47 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 12791 invoked from network); 24 Nov 2002 01:56:46 -0000 X-Authentication-Warning: pele.uniandes.edu.co: nobody set sender to s-zarrat@uniandes.edu.co using -f Message-ID: <1038103012.3de031e440e33@correo2.uniandes.edu.co> Date: Sat, 23 Nov 2002 20:56:52 -0500 From: Saul Rodrigo =?ISO-8859-1?B?WmFycmF0ZSBD4XJkZW5hcw==?= To: "cocoon-users@xml.apache.org" Subject: Problem with a store procedure in a XSP page MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1 X-Originating-IP: 200.91.196.192 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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 sgcWebXML_oracle_pool { CALL JBDPL.validar ( ,Oracle , ) } In the sitemap I have 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. To unsubscribe, e-mail: For additional commands, e-mail: