Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
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 ?
Find more posts tagged with
Comments
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
<blockquote class='ipsBlockquote' data-author="mwilliams"><p>Hi mazha,<br />
<br />
You should be able to use any version of BIRT. You just need to be sure that you have the correct jdbc driver.<br />
<br />
Hope this helps.</p></blockquote>
<br />
Can you tell me the reason please?<br />
The JDBC driver files which I get from ?IBMdweSQLLIBjava are db2jcc.jar and db2jcc_license_cu.jar. <br />
The log file in the server as follow:<br />
[08-11-24 11:40:45:906 CST] 0000002c SystemErr R at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:270)<br />
[08-11-24 11:40:45:906 CST] 0000002c SystemErr R ... 32 more<br />
[08-11-24 15:29:07:859 CST] 0000002d SystemErr R java.lang.reflect.InvocationTargetException<br />
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)<br />
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br />
[08-11-24 15:29:09:125 CST] 0000002d SystemErr R at java.lang.reflect.Method.invoke(Method.java:615)<br />
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:137)<br />
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.core.framework.Platform.startup(Platform.java:78)<br />
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.report.service.ReportEngineService.setEngineContext(Unknown Source)<br />
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.report.service.BirtViewerReportService.setContext(Unknown Source)<br />
[08-11-24 15:29:09:156 CST] 0000002d SystemErr R at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(Unknown Source)<br />
[08-11-24 15:29:09:171 CST] 0000002d SystemErr R at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(Unknown Source)<br />
[08-11-24 15:29:09:171 CST] 0000002d SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)<br />
[08-11-24 15:29:09:171 CST] 0000002d SystemErr R at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br />
[08-11-24 15:29:09:218 CST] 0000002d SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
[08-11-24 15:29:09:218 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)<br />
[08-11-24 15:29:09:296 CST] 0000002d SystemErr R Caused by: java.lang.IllegalStateException: Platform already running<br />
at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:270)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br />
at java.lang.reflect.Method.invoke(Method.java:615)<br />
at org.eclipse.birt.core.framework.osgi.OSGILauncher.startup(OSGILauncher.java:137)<br />
at org.eclipse.birt.core.framework.Platform.startup(Platform.java:78)<br />
at org.eclipse.birt.report.service.ReportEngineService.setEngineContext(Unknown Source)<br />
at org.eclipse.birt.report.service.BirtViewerReportService.setContext(Unknown Source)<br />
at org.eclipse.birt.report.servlet.ViewerServlet.__getContext(Unknown Source)<br />
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(Unknown Source)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)<br />
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989)<br />
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:501)<br />
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464)<br />
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3252)<br />
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:264)<br />
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)<br />
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)<br />
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:112)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383)<br />
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:263)<br />
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)<br />
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)<br />
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)<br />
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)<br />
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)<br />
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)<br />
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195)<br />
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743)<br />
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873)<br />
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)<br />
[08-11-24 15:29:09:468 CST] 0000002d SystemErr R at org.eclipse.core.runtime.adaptor.EclipseStarter.startup(EclipseStarter.java:270)<br />
[08-11-24 15:29:09:468 CST] 0000002d SystemErr R ... 34 more <br />
<br />
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
<blockquote class='ipsBlockquote' data-author="mwilliams"><p>mazha,<br />
<br />
Can you explain more about your application and what you're wanting to do?</p></blockquote>
<br />
I want to design the report by using birt on WebSphere Application Server V6.<br />
<br />
Database is db2 v9.5. <br />
I integrate them , but i get the wrong page of birt runtime's example report,<br />
which birt runtime can run right on tomcat server. why is it?<br />
The information has been in the Attach Files.
