You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Saul Rodrigo Zarrate Cárdenas <s-...@uniandes.edu.co> on 2002/11/24 02:56:52 UTC
Problem with a store procedure in a XSP page
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>