Problem with Report

Andrea Ianni

(161●19●16) Feb 20 '09, 9:27 a.m.

Hi,
I created a report with JDBC Data Source and I see it correctly in Birt report Viewer but when I create a new report using Report Template I have this error:

Cannot open the connection for the driver&#58; org.eclipse.birt.report.data.oda.jdbc

Cannot load JDBC Driver class&#58; com.ibm.db2.jcc.DB2Driver  &#40; 1 time&#40;s&#41; &#41;

detail &#58; org.eclipse.birt.report.data.adapter.api.AdapterException&#58; Cannot open the connection for the driver&#58; org.eclipse.birt.report.data.oda.jdbc

Cannot load JDBC Driver class&#58; com.ibm.db2.jcc.DB2Driver 

 at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute&#40;DataRequestSessionImpl.java&#58;457&#41;

 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery&#40;DteDataEngine.java&#58;151&#41;

 at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery&#40;DteDataEngine.java&#58;117&#41;

 at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute&#40;AbstractDataEngine.java&#58;182&#41;

 at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries&#40;ExtendedGenerateExecutor.java&#58;197&#41;

 at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute&#40;ExtendedGenerateExecutor.java&#58;63&#41;

 at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute&#40;ExtendedItemExecutor.java&#58;60&#41;

 at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute&#40;SuppressDuplicateItemExecutor.java&#58;42&#41;

 at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute&#40;WrappedReportItemExecutor.java&#58;45&#41;

 at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute&#40;LocalizedReportItemExecutor.java&#58;33&#41;

 at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes&#40;HTMLBlockStackingLM.java&#58;63&#41;

 at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout&#40;HTMLPageLM.java&#58;85&#41;

 at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout&#40;HTMLReportLayoutEngine.java&#58;106&#41;

 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun&#40;RunAndRenderTask.java&#58;140&#41;

 at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run&#40;RunAndRenderTask.java&#58;68&#41;

 at com.ibm.team.reports.service.internal.InternalReportService.getRenderedReport&#40;InternalReportService.java&#58;1582&#41;

 at sun.reflect.NativeMethodAccessorImpl.invoke0&#40;Native Method&#41;

 at sun.reflect.NativeMethodAccessorImpl.invoke&#40;NativeMethodAccessorImpl.java&#58;79&#41;

 at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;

 at java.lang.reflect.Method.invoke&#40;Method.java&#58;618&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;375&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;361&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;55&#41;

 at $Proxy144.getRenderedReport&#40;Unknown Source&#41;

 at com.ibm.team.reports.service.internal.ReportRestService$2.run&#40;ReportRestService.java&#58;416&#41;

 at com.ibm.team.reports.service.internal.ReportRestService.getRenderedReport&#40;ReportRestService.java&#58;423&#41;

 at com.ibm.team.reports.service.internal.ReportRestService.getRenderedQuery&#40;ReportRestService.java&#58;364&#41;

 at sun.reflect.NativeMethodAccessorImpl.invoke0&#40;Native Method&#41;

 at sun.reflect.NativeMethodAccessorImpl.invoke&#40;NativeMethodAccessorImpl.java&#58;79&#41;

 at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;

 at java.lang.reflect.Method.invoke&#40;Method.java&#58;618&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke&#40;ExportProxyServiceRecord.java&#58;375&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0&#40;ExportProxyServiceRecord.java&#58;361&#41;

 at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke&#40;ExportProxyServiceRecord.java&#58;55&#41;

 at $Proxy146.getRenderedQuery&#40;Unknown Source&#41;

 at sun.reflect.NativeMethodAccessorImpl.invoke0&#40;Native Method&#41;

 at sun.reflect.NativeMethodAccessorImpl.invoke&#40;NativeMethodAccessorImpl.java&#58;79&#41;

 at sun.reflect.DelegatingMethodAccessorImpl.invoke&#40;DelegatingMethodAccessorImpl.java&#58;43&#41;

 at java.lang.reflect.Method.invoke&#40;Method.java&#58;618&#41;

 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService&#40;AbstractTeamServerServlet.java&#58;493&#41;

 at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service&#40;AbstractTeamServerServlet.java&#58;1379&#41;

 at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;803&#41;

 at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service&#40;ServletManager.java&#58;180&#41;

 at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest&#40;ServletRegistration.java&#58;90&#41;

 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias&#40;ProxyServlet.java&#58;111&#41;

 at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service&#40;ProxyServlet.java&#58;75&#41;

 at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;803&#41;

 at org.eclipse.equinox.servletbridge.BridgeServlet.service&#40;BridgeServlet.java&#58;115&#41;

 at javax.servlet.http.HttpServlet.service&#40;HttpServlet.java&#58;803&#41;

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter&#40;ApplicationFilterChain.java&#58;269&#41;

 at org.apache.catalina.core.ApplicationFilterChain.doFilter&#40;ApplicationFilterChain.java&#58;188&#41;

 at org.apache.catalina.core.StandardWrapperValve.invoke&#40;StandardWrapperValve.java&#58;210&#41;

 at org.apache.catalina.core.StandardContextValve.invoke&#40;StandardContextValve.java&#58;174&#41;

 at org.apache.catalina.authenticator.AuthenticatorBase.invoke&#40;AuthenticatorBase.java&#58;525&#41;

 at org.apache.catalina.core.StandardHostValve.invoke&#40;StandardHostValve.java&#58;127&#41;

 at org.apache.catalina.valves.ErrorReportValve.invoke&#40;ErrorReportValve.java&#58;117&#41;

 at org.apache.catalina.core.StandardEngineValve.invoke&#40;StandardEngineValve.java&#58;108&#41;

 at org.apache.catalina.connector.CoyoteAdapter.service&#40;CoyoteAdapter.java&#58;151&#41;

 at org.apache.coyote.http11.Http11Processor.process&#40;Http11Processor.java&#58;870&#41;

 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection&#40;Http11BaseProtocol.java&#58;665&#41;

 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket&#40;PoolTcpEndpoint.java&#58;528&#41;

 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt&#40;LeaderFollowerWorkerThread.java&#58;81&#41;

 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run&#40;ThreadPool.java&#58;685&#41;

 at java.lang.Thread.run&#40;Thread.java&#58;810&#41;

Can you help me?
Any suggestion?

Thanks
Andrea

0 votes

3 answers

7,795 views

0 votes

3 answers

Permanent link

Rafik Jaouani

JAZZ DEVELOPER (5.0k●1●6) Feb 20 '09, 8:26 p.m.

You will need to deploy the jdbc driver jars with the BIRT report engine on the server side, check for the following plugin/folder and add the jdbc driver there.
org.eclipse.birt.report.data.oda.jdbc/drivers

0 votes

Permanent link

Andrea Ianni

(161●19●16) Feb 23 '09, 9:42 a.m.

You will need to deploy the jdbc driver jars with the BIRT report engine on the server side, check for the following plugin/folder and add the jdbc driver there.
org.eclipse.birt.report.data.oda.jdbc/drivers

Sorry,
you could describe better what I should do and what prerequisites do I need?

thanks

0 votes

Permanent link

Andrea Ianni

(161●19●16) Feb 23 '09, 12:09 p.m.

You will need to deploy the jdbc driver jars with the BIRT report engine on the server side, check for the following plugin/folder and add the jdbc driver there.
org.eclipse.birt.report.data.oda.jdbc/drivers

Sorry,
you could describe better what I should do and what prerequisites do I need?

thanks

The problem is that I don't have this folder org.eclipse.birt.report.data.oda.jdbc.

Where should this folder?

Thanks

0 votes

Your answer

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers

Answers and Comments

Question details

rational-team-concert

× 43,033

Question asked: Feb 20 '09, 9:27 a.m.

Question was seen: 7,795 times

Last updated: Feb 20 '09, 9:27 a.m.

Problem with Report

Andrea Ianni

3 answers

7,795 views

0 votes

3 answers

Rafik Jaouani

Andrea Ianni

Andrea Ianni

Your answer

Follow this question

Question details

Related questions