On 05.Apr.2002 -- 05:57 PM, Argyn Kuketayev wrote:
> 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)
Could you please get me the source of the above file (sutdentdata_xsp.java) ?
For some reason ESQL does not obtain a CallableStatement. The java and the xsp
would help to debug that.
TIA
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
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]>
