Installing the BIRT Viewer in Tomcat

[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

<dataSet
defaultDisplayName="%dataset.query.sqltype"
id="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet">
...
...
...
<dataSet
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