does anybody here ever try cocoon excel report written by steve puente? you can reach the page at http://www.xml.com/pub/a/2003/01/22/cocoon-excel.html
i have read the tutorial article & tried the excel reports with apache cocoon and POI. when using mysql database, everythings done properly. very great! i try to implement the reports to oracle database, and seems i get some problems with the SQLTransformer class from cocoon, or perhaps, the oracle JDBC driver. i run the excel cocoon report with configuration below : - jdk 1.3 - tomcat 4.0 - cocoon excel report, (originally download war file from http://candlelightsoftware.com/downloads/cocoon-reports.war ) - oracle JDBC driver - classes12.jar (located in {tomcat_home}\common\lib) i have set the database setting (replaced the original mysql configuration with the oracle's) in web.xml, sitemap.xmap, cocoon.xconf. when running the reports (from the input form), no value of data appeared in excel template although the SQL give me result when checked on database. error.log show nothing, but in sitemap.log there is an exception : ============================================================================ ===================================== ... <message truncated> ... DEBUG (2003-08-18) 14:01.32:405 [sitemap.transformer.sql] (/reports-app/report/simple.xls) HttpProcessor[8080][3]/SQLTransformer$Query: NullPointerException, returning false. java.lang.NullPointerException at oracle.jdbc.driver.ScrollableResultSet.cacheRowAt(ScrollableResultSet.java:2 086) at oracle.jdbc.driver.ScrollableResultSet.isValidRow(ScrollableResultSet.java:2 060) 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.ja va:1206) at org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer. java:349) ... <message truncated> ... ============================================================================ ===================================== could somebody give me any help or suggestion about how to fix the problem? thank's in advanced. regards, heru hariyanto. software engineer. balicamp. email : [EMAIL PROTECTED] http://www.balicamp.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]