[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:808...le=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.

[RahulD]

Error Log:



error
--------------------------------------------------------------------------
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)
... 6 more
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
Dec 29, 2008 5:49:13 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

at org.eclipse.birt.data.engine.odaconsumer.ResultSet.throwDataException
(ResultSet.java:498)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.throwDataException
(ResultSet.java:490)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.close(ResultSet.ja
va:476)
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: 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)
... 6 more
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
Dec 29, 2008 5:49:14 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.getParameterS
electionList(BirtViewerReportService.java:789)
at org.eclipse.birt.report.presentation.aggregation.parameter.ComboBoxPa
rameterFragment.prepareParameterBean(ComboBoxParameterFragment.java:89)
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.dialog.ParameterDialogFragment_j
sp._jspService(ParameterDialogFragment_jsp.java:99)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
29)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:679)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:584)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:497)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment
.service(AbstractBaseFragment.java:82)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment
.callBack(AbstractBaseFragment.java:106)
at org.apache.jsp.webcontent.birt.pages.dialog.DialogContainerFragment_j
sp._jspService(DialogContainerFragment_jsp.java:126)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
29)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:679)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:584)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:497)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment
.service(AbstractBaseFragment.java:82)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment
.callBack(AbstractBaseFragment.java:106)
at org.apache.jsp.webcontent.birt.pages.layout.ReportDialogFragment_jsp.
_jspService(ReportDialogFragment_jsp.java:62)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
29)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)










Thanks,

RahulD

[RahulD]

I am using .mdb file which i have kept on c:\database.mdb
also for the same i have created Data Source Name (DSN)
by name db.

If something is wrong plz let me know.

Thanks

RahulD

[mwilliams]

Vishal KP & RahulD,

Are you using the designer to create your BIRT reports or are you using java? Are you able to run the reports in the designer without issue?

[RahulD]

Hi Michael,

I am using Actuate BIRT 2.3.2 Report Designer Professional for creating report but in that i have used some java scripting so as to modify some part of chart (chart scripting).
yeah, report is working fine without any issue.

Also i am interested in knowing the location, where .mdb file is supposed to be placed in Tomcat. I have created DSN using Microsoft Access Driver (.mdb).


Thanks,


RahulD

[RahulD]

Hi all,

I am publishing report created using BIRT 2.3.2 All in one report Designer on Tomact 5.5.27. I have copying WebViewerExample directory from Birt-Runtime 2.3.2. to webapps directory of Tomcat.

In my report i have created joint data set. I am not able to see my report on browser.

But when i deleted joint data set and related bindind on tables i can see my report on browser.

I looked in file located in WEB-INF\platform\ plugins\ org.eclipse.birt.report.data.oda.jdbc\plugin.xml where i can see

defaultDisplayName="%dataset.query.sqltype"
id="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet">
...
...
...
defaultDisplayName="%dataset.query.sptype"
id="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet">

...
...
...

but i am not able to find for joint data set.

I want to raise the question regarding this plugin.xml whether it is fine or need to add something in it.



Any kind of help w'll be appreciated !!



Thanks

RahulD

[evgeny]

Hi,

not sure if it is the solution to the original question, but at least it worked for me. I just copied the oracle ojdbc14.jar to \Tomcat 6.0\webapps\birt-viewer\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc\drivers and my report is running.
You can find the ojdbc14.jar file here \oracle\product\10.2.0\db_2\jdbc\lib

Best

Evgeny