cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Saul Rodrigo Zarrate Cárdenas <s-zar...@uniandes.edu.co>
Subject Problem with a store procedure in a XSP page
Date Sun, 24 Nov 2002 01:56:52 GMT
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message