xml-xsp-dev 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 the exetution of a store procedure in esql
Date Tue, 19 Nov 2002 23:22:51 GMT
Hi

I have a Cocoon Version number 2.0.3.  I am working with Apache Tomcat version 
4.0.1
I have an Oracle Database and in that database I have a store procedure in a 
package with the next head

CREATE OR REPLACE PACKAGE JBDPL
AS
    PROCEDURE validar(nombreUsuario VARCHAR2, BD VARCHAR2, resultado OUT 
NUMBER);
END JBDPL;
/


I tested the store procedure, making the calling from Java and I didn't get 
any problem

I have a XSP page, where I have the next

<?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"
>  
   
 <page> 

  <title>Validacion de Usuarios</title>

  <content>
   <esql:connection> 
    <esql:pool>test_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>

And when i tried to load I have the next


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.matchN100B2
(C:\Archivos de programa\Apache Tomcat 4.0\work\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 Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:485)
	at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.process(C:\Archivos 
de programa\Apache Tomcat 4.0\work\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.matchN1036A(C:\Archivos de 
programa\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www\sitemap_xmap.java:4054)
	at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de 
programa\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www\sitemap_xmap.java:3187)
	at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de 
programa\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www\sitemap_xmap.java:3124)
	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:243)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:201)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke
(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2344)
	at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:164)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke
(AccessLogValve.java:462)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	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.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process
(HttpProcessor.java:1011)
	at org.apache.catalina.connector.http.HttpProcessor.run
(HttpProcessor.java:1106)
	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 Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www/SGCWebXML/logical/validar\validar_xsp.java:486)
	at org.apache.cocoon.generation.ServerPagesGenerator.generate
(ServerPagesGenerator.java:258)
	... 46 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 Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www/SGCWebXML/logical/validar\validar_xsp.java:486)
	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.matchN100B2
(C:\Archivos de programa\Apache Tomcat 4.0\work\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 Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www/SGCWebXML\sitemap_xmap.java:485)
	at org.apache.cocoon.www.SGCWebXML.sitemap_xmap.process(C:\Archivos 
de programa\Apache Tomcat 4.0\work\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.matchN1036A(C:\Archivos de 
programa\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www\sitemap_xmap.java:4054)
	at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de 
programa\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www\sitemap_xmap.java:3187)
	at org.apache.cocoon.www.sitemap_xmap.process(C:\Archivos de 
programa\Apache Tomcat 4.0\work\localhost\cocoon\cocoon-
files\org/apache/cocoon/www\sitemap_xmap.java:3124)
	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:243)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:201)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke
(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke
(StandardContext.java:2344)
	at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:164)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke
(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke
(AccessLogValve.java:462)
	at org.apache.catalina.core.StandardPipeline.invokeNext
(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	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.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke
(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke
(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process
(HttpProcessor.java:1011)
	at org.apache.catalina.connector.http.HttpProcessor.run
(HttpProcessor.java:1106)
	at java.lang.Thread.run(Thread.java:536)


request-uri

/cocoon/SGCWebXML/logical/validar/validar.xsp

path-info

SGCWebXML/logical/validar/validar.xsp


-------------------------------------------------------------------------------
-





Can anybody help me please?


Thank you

Saul Zarrate Cardenas


Mime
View raw message