Installing the BIRT Viewer in Tomcat

[RahulD]

Hi all,

After Installation of Tomcat 5.5.x on my system, and after Copying the Web Viewer Example directory to the webapps directory of my Tomcat installation.

I tried giving url "http://localhost:8080/birt-viewer/run?__report=Report\Person Group.rptdesign.

where Person Group.rptdesign resides in Report directort of Tomcat.

I got error saying
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
Cannot load JDBC Driver class: com.actuate.jdbc.oracle.OracleDriver.

Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class: com.actuate.jdbc.oracle.OracleDriver.

where i am going wrong? Can anybody tell me If any thing has to be added ?


Thanks for any reply!

RahulD

[mwilliams]

Hi RahulD,

Where did you put your driver inside the viewer? Does the test report work for you?

[RahulD]

Hi Michael,

I have pasted my drivers inside \WEB-INF\lib directory.

Yeah, test report is working fine but in reports where i have used report libraries that is not working i mean maset page entries are not appearing on browser.

If any modification has to be done then please let me know.

Thanks for your reply.

RahulD

[mwilliams]

RahulD,

Where did you put your libraries?

[RahulD]

Hi Michael,

Library location is WEB-INF\lib.
Can u repeat the steps for configuring BIRT Runtime,so that it will be helpful for me to get the clear idea.

Thanks for reply.

RahulD

[mwilliams]

RahulD,

The steps for deploying the viewer can be found here:

Installing the BIRT Viewer in Tomcat

However, if the test report works, you probably installed it correctly. As for the libraries, if you put them where your report designs are, they should work.

[vishalkp]

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.

[mwilliams]

Hi Vishal KP,

Where do you put your flat files?

[vishalkp]

Hello Michael,

I have kept the Access Database in system drive and created its DSN to access it.
The report is able to access the data but when we try to run the report thourgh Tomcat we are getting the above mentioned Error.

Is something Wrong in doing this.

Please do reply your Suggestion.

Thanks In Advance...

With Regards,
Vishal KP.

[RahulD]

Hi all,

Like vishalKp i am also not able to see run report on browser with url as:
http://localhost:8080/birt-viewer/ru...e=my+parameter

I am attaching my error.bmp file so as to get clear idea.
I am getting error in result set.


Thanks & regards,

RahulD.