Error connecting BIRT and DB2 [message #540079] |
Mon, 14 June 2010 19:36 |
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 19:37] Report message to a moderator
|
|
|
|
Re: Error connecting BIRT and DB2 [message #540107 is a reply to message #540079] |
Mon, 14 June 2010 22:26 |
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)
>
> =========================================
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.04793 seconds