I have two nested queries and one nested stored procedure call. I couldn't
get resluts from the stored procedure. Cocoon says:
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.ClassCastException:
oracle.jdbc.driver.OraclePreparedStatement
here's a fragment of XSP.
<esql:execute-query>
<esql:query>
select ...
</esql:query>
<esql:results>
<rowset name="quals">
<esql:row-results>
<row>
<esql:get-columns/>
<esql:execute-query>
<esql:call needs-query="true" >
{call PKG_STUDENT.STUD_QUAL_STATUS(
<esql:parameter direction="in" type="string"><esql:get-string
ancestor="2" column="ID"/></esql:parameter>,
<esql:parameter direction="in" type="string"><esql:get-string
ancestor="1" column="qual_id"/></esql:parameter>,
<esql:parameter direction="out" type="String"/>,
<esql:parameter direction="out" type="date"/>,
<esql:parameter direction="out" type="Int"/>)}
</esql:call>
<esql:call-results>
<esql:results>
<esql:result><xsp:expr>(ResultSet)<esql:get-object
column="2" from-call="true" /></xsp:expr></esql:result>
<esql:row-results>
<status><esql:get-string column="3"/></status>
<remdays><esql:get-int column="5"/></remdays>
</esql:row-results>
</esql:results>
</esql:call-results>
</esql:execute-query>
</row>
</esql:row-results>
</rowset>
</esql:results>
</esql:execute-query>
I couldn't get what's wrong.
Thanks
Argyn
stack trace:
=========================================
Original exception : java.lang.ClassCastException:
oracle.jdbc.driver.OraclePreparedStatement
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.getCallableStatem
ent(EsqlQuery.java:194)
at
org.apache.cocoon.www.docs.samples.xsp.studentdata_xsp.generate(C:\JBoss-2.4
.1_Tomcat-3.2.3\tomcat\work\localhost_8080%2Fargyn\cocoon-files\org/apache/c
ocoon/www/docs/samples/xsp\studentdata_xsp.java:820)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:260)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:251)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:399)
at
org.apache.cocoon.www.sitemap_xmap.matchN1057A(C:\JBoss-2.4.1_Tomcat-3.2.3\t
omcat\work\localhost_8080%2Fargyn\cocoon-files\org/apache/cocoon/www\sitemap
_xmap.java:7078)
at
org.apache.cocoon.www.sitemap_xmap.process(C:\JBoss-2.4.1_Tomcat-3.2.3\tomca
t\work\localhost_8080%2Fargyn\cocoon-files\org/apache/cocoon/www\sitemap_xma
p.java:3056)
at
org.apache.cocoon.www.sitemap_xmap.process(C:\JBoss-2.4.1_Tomcat-3.2.3\tomca
t\work\localhost_8080%2Fargyn\cocoon-files\org/apache/cocoon/www\sitemap_xma
p.java:2519)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:222)
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:983)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81
2)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Unknown Source)
====================================
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
