Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Error connecting BIRT and DB2
Error connecting BIRT and DB2 [message #540079] Mon, 14 June 2010 15:36 Go to next message
megiddo7562  is currently offline megiddo7562
Messages: 2
Registered: June 2010
Junior Member
Hello guys... I'm a newbie in programming Java and BIRT.

Right now, I am trying to connect a DB2 server with my BIRT however I am receiving this error, everytime I try to test the connection.


Here are the details:

BIRT version: 2.3
IDE: Rational Team Concert 2.0.0.2

DB2 driver version -> 1.3.1

driver: com.ibm.db2.jcc.DB2Driver
driver URL: jdbc:db2://localhost:50000/SampleDB
username: user001
password: password
JNDI URL: java:comp/env/jdbc/sampledb


======================================

org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2/6000 databases. To connect to this DB2 server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must ....
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:222)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:153)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryC reateConnection(JDBCDriverManager.java:654)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test Connection(JDBCDriverManager.java:582)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test Connection(JDBCDriverManager.java:466)
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test Connection(JDBCDriverManager.java:514)
at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.t estConnection(DriverLoader.java:118)
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper.testConnection(JDBCSelectionPageHelper.java:635 )
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper.access$7(JDBCSelectionPageHelper.java:619)
at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti onPageHelper$7.widgetSelected(JDBCSelectionPageHelper.java:5 41)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListe ner.java:228)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3840)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3439)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:825 )
at org.eclipse.jface.window.Window.open(Window.java:801)
at org.eclipse.birt.report.designer.ui.actions.NewDataSourceAct ion.run(NewDataSourceAction.java:126)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498 )
at org.eclipse.jface.action.ActionContributionItem.handleWidget Selection(ActionContributionItem.java:583)
at org.eclipse.jface.action.ActionContributionItem.access$2(Act ionContributionItem.java:500)
at org.eclipse.jface.action.ActionContributionItem$5.handleEven t(ActionContributionItem.java:411)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :84)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja va:3840)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3439)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav a:2384)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:22 00)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:495)
at org.eclipse.core.databinding.observable.Realm.runWithDefault (Realm.java:288)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work bench.java:490)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j ava:149)
at org.eclipse.ui.internal.ide.application.IDEApplication.start (IDEApplication.java:113)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(Eclips eAppHandle.java:193)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher .start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:386)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS tarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 549)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
at org.eclipse.equinox.launcher.Main.run(Main.java:1236)

=========================================

[Updated on: Mon, 14 June 2010 15:37]

Report message to a moderator

Re: Error connecting BIRT and DB2 [message #540091 is a reply to message #540079] Mon, 14 June 2010 16:42 Go to previous messageGo to next message
Steve Schafer is currently offline Steve Schafer
Messages: 22
Registered: December 2009
Junior Member
It would appear you need to use a different JDBC driver. If you have the licensed JDBC driver described in the error message, you can install it using the [Manage Drivers] button on the New JDBC Data Source wizard page.
Re: Error connecting BIRT and DB2 [message #540107 is a reply to message #540079] Mon, 14 June 2010 18:26 Go to previous messageGo to next message
Eclipse User
Originally posted by: remkus.wideopenwest.com

Make sure you copy the db2jcc_license_cu.jar file into the drivers
directory as well as the db2jcc.jar ... you need both of them.

You should be able to find the db2jcc_license_cu.jar file in the java
directory where you installed DB2. It doesn't matter if DB2 is
installed on a different OS than BIRT.

Thanks
On 06/14/2010 03:36 PM, megiddo7562 wrote:
> Hello guys... I'm a newbie in programming Java and BIRT.
>
> Right now, I am trying to connect a DB2 server with my BIRT however I am
> receiving this error, everytime I try to test the connection.
>
>
> Here are the details:
>
> BIRT version: 2.3
> IDE: Rational Team Concert 2.0.0.2
> DB2 driver version -> 1.3.1
>
> driver: com.ibm.db2.jcc.DB2Driver
> driver URL: jdbc:db2://localhost:50000/SampleDB
> username: user001 password: password
> JNDI URL: java:comp/env/jdbc/limsds
>
>
> ======================================
>
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error
> in get connection, The version of the IBM Universal JDBC driver in use
> is not licensed for connectivity to QDB2/6000 databases. To connect to
> this DB2 server, please obtain a licensed copy of the IBM DB2 Universal
> Driver for JDBC and SQLJ. An appropriate license file
> db2jcc_license_*.jar for this target platform must ....
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo
> nnect(JDBCDriverManager.java:222)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC
> onnection(JDBCDriverManager.java:153)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryC
> reateConnection(JDBCDriverManager.java:654)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test
> Connection(JDBCDriverManager.java:582)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test
> Connection(JDBCDriverManager.java:466)
> at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.test
> Connection(JDBCDriverManager.java:514)
> at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.t
> estConnection(DriverLoader.java:118)
> at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti
> onPageHelper.testConnection(JDBCSelectionPageHelper.java:635 )
> at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti
> onPageHelper.access$7(JDBCSelectionPageHelper.java:619)
> at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelecti
> onPageHelper$7.widgetSelected(JDBCSelectionPageHelper.java:5 41)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListe
> ner.java:228)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja
> va:3840)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3439)
> at org.eclipse.jface.window.Window.runEventLoop(Window.java:825 )
> at org.eclipse.jface.window.Window.open(Window.java:801)
> at org.eclipse.birt.report.designer.ui.actions.NewDataSourceAct
> ion.run(NewDataSourceAction.java:126)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:498 )
> at org.eclipse.jface.action.ActionContributionItem.handleWidget
> Selection(ActionContributionItem.java:583)
> at org.eclipse.jface.action.ActionContributionItem.access$2(Act
> ionContributionItem.java:500)
> at org.eclipse.jface.action.ActionContributionItem$5.handleEven
> t(ActionContributionItem.java:411)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java :84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1003)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.ja
> va:3840)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java :3439)
> at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.jav
> a:2384)
> at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2348)
> at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:22 00)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:495)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault
> (Realm.java:288)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Work
> bench.java:490)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.j
> ava:149)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start
> (IDEApplication.java:113)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(Eclips
> eAppHandle.java:193)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher
> .runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher
> .start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS
> tarter.java:386)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseS
> tarter.java:179)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:79)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:618)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java: 549)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1236)
>
> =========================================
>
Re: Error connecting BIRT and DB2 [message #540232 is a reply to message #540079] Tue, 15 June 2010 08:58 Go to previous message
megiddo7562  is currently offline megiddo7562
Messages: 2
Registered: June 2010
Junior Member
@all: thanks for the quick replies guys

@steve: I figured that much so right now I am in the process of securing a licensed copy of the DB2 driver.

@eclipse user: I already did that and it still not working... I also tried to download a new version of the driver but it still does not work.
Previous Topic:deleting empty rows
Next Topic:Chart-Image generation for second WebApp
Goto Forum:
  


Current Time: Sat Aug 30 22:29:24 EDT 2014

Powered by FUDForum. Page generated in 0.01662 seconds