I just tried the latest from the cocoon_2_0_3_branch and got...
org.apache.cocoon.components.language.LanguageException: Error compiling control_xsp:
Line 448, column 45: unreported exception: java.lang.IllegalAccessException; must be
caught or declared to be thrown
Line 448 in control_xsp.java is:
registerOutParameter(1,
EsqlQuery.getType("oracle.jdbc.driver.OracleTypes.CURSOR"));
EsqlQuery.getType(String typeName) throws ClassNotFoundException,
NoSuchFieldException, IllegalAccessException
These need to be declared as thrown in the generated code (or caught, logged, and
something else thrown).
Also, I don't think paging works within esql:call-results/esql:use-results e.g.:
<esql:call-results>
<esql:use-results>
<esql:result><esql:get-object column="8" from-call="true"/></esql:result>
<esql:skip-rows><xsp:expr>sessionData.getRow() -
1</xsp:expr></esql:skip-rows>
<esql:max-rows><xsp:expr>sessionData.getRowsPerPage()</xsp:expr></esql:max-rows>
I'll look into this one next week.
Regards,
Neil.
-----Original Message-----
From: Christian Haul [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 August 2002 6:51 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: esql patch for paging and ResultSets from Oracle stored
procs
[snip]
> Changed get-Sql-Type so that an unrecognized type is copied verbatim into
> the java code without having "Types."
Not applied -- I believe it's better to follow the SQLTransformer here
that uses Class.forName(). Reason: reduce XSP dependency from
DBMS. Drawback: Since it's runtime it's slightly slower, OTOH an
intelligent compiler could optimize it away. Hence, different patch
applied.
[snip]
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
