You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by mahesh todlage <mt...@yahoo.com> on 2003/07/14 14:08:24 UTC
How to configure oracle in cocoon for generating excel report
hi,
I am trying to run the http://localhost:8080/cocoon-reports2/report/simple.rpt example using oracle9i database instead of mysql.
I made following changes in web.xml
<init-param>
<param-name>load-class</param-name>
<param-value>oracle.jdbc.driver.OracleDriver</param-value>
</init-param>
Then i also made following changes in sitemap.xmap file
<map:transform type="sql">
<map:parameter name="dburl" value="jdbc:oracle:thin:@172.28.32.12:1521:AQUOTE" />
<map:parameter name="username" value="test" />
<map:parameter name="password" value="test" />
</map:transform>
and kept classes12.jar in lib folder.
Restarted the server .But when i click on genreate report button it displays the .xls file in browser but doesnot show any values from database.
In sitemap.log error file it gives following error
Thread-6/SQLTransformer$Query: EXECUTING SELECT
SUM(amount) as sum,
date1
FROM transactions GROUP BY date1
DEBUG (2003-07-14) 05:24.40:281 [sitemap.transformer.sql] (/cocoon-reports2/report/simple.xls) Thread-6/AbstractSAXTransformer: BEGIN startTransformingElement uri=http://apache.org/cocoon/SQL/2.0, name=rowset, raw=rowset, attr=org.xml.sax.helpers.AttributesImpl@10e4fd7)
DEBUG (2003-07-14) 05:24.40:281 [sitemap.transformer.sql] (/cocoon-reports2/report/simple.xls) Thread-6/AbstractSAXTransformer: END startTransformingElement
DEBUG (2003-07-14) 05:24.40:281 [sitemap.transformer.sql] (/cocoon-reports2/report/simple.xls) Thread-6/SQLTransformer$Query: NullPointerException, returning false.
java.lang.NullPointerException
at oracle.jdbc.driver.ScrollableResultSet.cacheRowAt(ScrollableResultSet.java:2086)
at oracle.jdbc.driver.ScrollableResultSet.isValidRow(ScrollableResultSet.java:2060)
at oracle.jdbc.driver.ScrollableResultSet.isEmptyResultSet(ScrollableResultSet.java:2027)
at oracle.jdbc.driver.ScrollableResultSet.next(ScrollableResultSet.java:333)
at org.apache.cocoon.transformation.SQLTransformer$Query.next(SQLTransformer.java:1166)
at org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:333)
at org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:462)
at org.apache.cocoon.transformation.SQLTransformer.endTransformingElement(SQLTransformer.java:769)
at org.apache.cocoon.transformation.AbstractSAXTransformer.endElement(AbstractSAXTransformer.java:351)
at org.apache.xalan.transformer.ResultTreeHandler.endElement(ResultTreeHandler.java:307)
at org.apache.xalan.templates.ElemCopy.execute(ElemCopy.java:163)
at org.apache.xalan.templates.ElemApplyTemplates.transformSelectedNodes(ElemApplyTemplates.java:423)
at org.apache.xalan.templates.ElemApplyTemplates.execute(ElemApplyTemplates.java:226)
at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2182)
at org.apache.xalan.templates.ElemCopy.execute(ElemCopy.java:159)
at org.apache.xalan.templates.ElemApplyTemplates.transformSelectedNodes(ElemApplyTemplates.java:423)
at org.apache.xalan.templates.ElemApplyTemplates.execute(ElemApplyTemplates.java:226)
at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2182)
at org.apache.xalan.templates.ElemCopy.execute(ElemCopy.java:159)
at org.apache.xalan.templates.ElemApplyTemplates.transformSelectedNodes(ElemApplyTemplates.java:423)
at org.apache.xalan.templates.ElemApplyTemplates.execute(ElemApplyTemplates.java:226)
at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2182)
at org.apache.xalan.templates.ElemLiteralResult.execute(ElemLiteralResult.java:678)
at org.apache.xalan.templates.ElemApplyTemplates.transformSelectedNodes(ElemApplyTemplates.java:423)
at org.apache.xalan.templates.ElemApplyTemplates.execute(ElemApplyTemplates.java:226)
at org.apache.xalan.transformer.TransformerImpl.executeChildTemplates(TransformerImpl.java:2182)
at org.apache.xalan.transformer.TransformerImpl.applyTemplateToNode(TransformerImpl.java:2008)
at org.apache.xalan.transformer.TransformerImpl.transformNode(TransformerImpl.java:1171)
at org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3135)
at java.lang.Thread.run(Thread.java:536)
DEBUG (2003-07-14) 05:24.40:281 [sitemap.transformer.sql] (/cocoon-reports2/report/simple.xls) Thread-6/AbstractSAXTransformer: BEGIN endTransformingElement uri=http://apache.org/cocoon/SQL/2.0, name=rowset, raw=rowset)
DEBUG (2003-07-14) 05:24.40:281 [sitemap.transformer.sql] (/cocoon-reports2/report/simple.xls) Thread-6/AbstractSAXTransformer: END endTransformingElement
Mahesh Todlage
Cell number 9422358534
---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!