Hello Michael,
Actually i am also trying the same thing.
I was able to get it worked fine for reports with sample database.
But when I try for Reports with Flat Files and JDBC data Source, I get the error as Cannot load driver connection.
Even i have added all the required Drivers inside WEB-INF\plugin\...oda.jdbc\drivers directory.
I got this error:
WARNING: Unable to find required classes (javax.activation.DataHandler and javax
.mail.internet.MimeMultipart). Attachment support is disabled.
Jun 24, 2009 2:40:41 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension: driverClass=org.apache.derby.jdbc.Embedde
dDriver, connectionFactory=null
Jun 24, 2009 2:40:41 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
loadDriverExtensions
INFO: Found JDBC driverinfo extension: driverClass=org.eclipse.birt.report.data.
oda.sampledb.Driver, connectionFactory=org.eclipse.birt.report.data.oda.sampledb
.SampleDBJDBCConnectionFactory
Jun 24, 2009 2:40:41 AM org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager
findDriver
INFO: Loaded JDBC driver class in class path: sun.jdbc.odbc.JdbcOdbcDriver
Jun 24, 2009 2:40:44 AM org.eclipse.birt.data.engine.odaconsumer.ResultSet close
SEVERE: Cannot close the result set.
Cannot close the result set.
SQL error #1: ResultSet is closed
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot close the result set
.
SQL error #1: ResultSet is closed
;
java.sql.SQLException: ResultSet is closed
at org.eclipse.birt.report.data.oda.jdbc.ResultSet.close(ResultSet.java:
131)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.c
lose(OdaResultSet.java:106)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.close(ResultSet.ja
va:472)
at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.close
(SimpleResultSet.java:79)
at org.eclipse.birt.data.engine.impl.ResultIterator.close(ResultIterator
.java:895)
at org.eclipse.birt.data.engine.impl.ResultIterator$1.dataEngineShutdown
(ResultIterator.java:169)
at org.eclipse.birt.data.engine.impl.DataEngineImpl.shutdown(DataEngineI
mpl.java:575)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.shut
down(DataRequestSessionImpl.java:378)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.shutdown(A
bstractDataEngine.java:333)
at org.eclipse.birt.report.engine.executor.ExecutionContext.close(Execut
ionContext.java:489)
at org.eclipse.birt.report.engine.api.impl.EngineTask.close(EngineTask.j
ava:1174)
at org.eclipse.birt.report.service.BirtViewerReportService.getSelectionL
istForCascadingGroup(BirtViewerReportService.java:754)
at org.eclipse.birt.report.presentation.aggregation.parameter.ComboBoxPa
rameterFragment.getParameterSelectionListForCascadingGroup(ComboBoxParameterFrag
ment.java:117)
at org.eclipse.birt.report.presentation.aggregation.parameter.ComboBoxPa
rameterFragment.prepareParameterBean(ComboBoxParameterFragment.java:79)
at org.eclipse.birt.report.presentation.aggregation.parameter.ScalarPara
meterFragment.doService(ScalarParameterFragment.java:91)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment
.service(AbstractBaseFragment.java:76)
at org.apache.jsp.webcontent.birt.pages.parameter.ParameterGroupFragment
_jsp._jspService(ParameterGroupFragment_jsp.java:133)
Caused by: java.sql.SQLException: ResultSet is closed
at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.clearWarnings(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.close(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.ResultSet.close(ResultSet.java:
126)
... 104 more
Jun 24, 2009 2:41:10 AM org.eclipse.birt.data.engine.odaconsumer.ResultSet close
SEVERE: Cannot close the result set.
Cannot close the result set.
SQL error #1: ResultSet is closed
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot close the result set
.
SQL error #1: ResultSet is closed
;
java.sql.SQLException: ResultSet is closed
at org.eclipse.birt.report.data.oda.jdbc.ResultSet.close(ResultSet.java:
131)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSet.c
lose(OdaResultSet.java:106)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.close(ResultSet.ja
va:472)
at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.close
(SimpleResultSet.java:79)
at org.eclipse.birt.data.engine.executor.transform.SimpleResultSet.final
ize(SimpleResultSet.java:88)
at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
at java.lang.ref.Finalizer.runFinalizer(Unknown Source)
at java.lang.ref.Finalizer.access$100(Unknown Source)
at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
Caused by: java.sql.SQLException: ResultSet is closed
at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.clearWarnings(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.close(Unknown Source)
at org.eclipse.birt.report.data.oda.jdbc.ResultSet.close(ResultSet.java:
126)
... 8 more
org.eclipse.birt.data.engine.core.DataException: Cannot close the result set.
Cannot close the result set.
SQL error #1: ResultSet is closed
Please reply your Suggestion.
Thanks In Advance.
With Regards,
Vishal KP.
|