BIRT with DB2 DWE

[mazha]

which version of birt runtime is compatible with dwe v9.5 ?
if i use the old version of birt runtime ,what will happen ?

[mwilliams]

Hi mazha,

You should be able to use any version of BIRT. You just need to be sure that you have the correct jdbc driver.

Hope this helps.

[Erick]

Hi

We work with Birt and DB2 9.5 (DWE) and 9.5.1 (InfoSphere), only you need DB2 9.5.X JDBC driver, it only work with DB2 (RDBMS), Birt can't work with DB2 Cube views (OLAP) or Cubing Services.

[mazha]

Originally Posted by mwilliams

Hi mazha,

You should be able to use any version of BIRT. You just need to be sure that you have the correct jdbc driver.

Hope this helps.

Can you tell me the reason please?
The JDBC driver files which I get from …\IBM\dwe\SQLLIB\java are db2jcc.jar and db2jcc_license_cu.jar.
The log file in the server as follow:
[08-11-24 11:40:45:906 CST] 0000002c SystemErr R at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:270)
[08-11-24 11:40:45:906 CST] 0000002c SystemErr R ... 32 more
[08-11-24 15:29:07:859 CST] 0000002d SystemErr R java.lang.reflect.InvocationTargetException
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at java.lang.reflect.Method.invoke(Method.java:615)
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:137)
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.core.framework.Platform.startup(Platform.java:78)
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.report.service.ReportEngineService.setEngineContext(Unknown Source)
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.report.service.BirtViewerReportService.setContext(Unknown Source)
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(Unknown Source)
[08-11-24 15:29:09:171 CST] 0000002d SystemErr R at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(Unknown Source)
[08-11-24 15:29:09:171 CST] 0000002d SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
[08-11-24 15:29:09:171 CST] 0000002d SystemErr R at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
[08-11-24 15:29:09:218 CST] 0000002d SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
[08-11-24 15:29:09:218 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R Caused by: java.lang.IllegalStateException: Platform already running
at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:270)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:137)
at org.eclipse.birt.core.framework.Platform.startup(Platform.java:78)
at org.eclipse.birt.report.service.ReportEngineService.setEngineContext(Unknown Source)
at org.eclipse.birt.report.service.BirtViewerReportService.setContext(Unknown Source)
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(Unknown Source)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
[08-11-24 15:29:09:468 CST] 0000002d SystemErr R at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:270)
[08-11-24 15:29:09:468 CST] 0000002d SystemErr R ... 34 more

In my computer ,it has the sun jdk ,can it effects the result ?

[mwilliams]

mazha,

Can you explain more about your application and what you're wanting to do?

[mazha]

Originally Posted by mwilliams

mazha,

Can you explain more about your application and what you're wanting to do?

I want to design the report by using birt on WebSphere Application Server V6.

Database is db2 v9.5.
I integrate them , but i get the wrong page of birt runtime's example report,
which birt runtime can run right on tomcat server. why is it?
The information has been in the Attach Files.