How to setup a BIRT JDBC Data Source to Jazz Repository
I need to create reports that include custom attributes, I do not want to have to extend the data warehouse. I am having issues creating a BIRT JDBD Data Source. Here are the values that I used to configure the data source:
Driver Class: org.apache.derby.jdbc.EmbeddedDriver Database URL Syntax Template: jdbc:derby:DATABASE* Database URL: jdbc:derby:C:/RTC/jazz/server/repositoryDB User Name and Password: left blank JNDI URL: left blank When I test the connection I get the following error message: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to start database 'C:/RTC/jazz/server/repositoryDB', see the next exception for details. at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:522) at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:108) at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:622) at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$7(JDBCSelectionPageHelper.java:606) at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$6.widgetSelected(JDBCSelectionPageHelper.java:528) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) at org.eclipse.jface.window.Window.runEventLoop(Window.java:820) at org.eclipse.jface.window.Window.open(Window.java:796) at org.eclipse.birt.report.designer.ui.actions.NewDataSourceAction.run(NewDataSourceAction.java:90) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:546) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) Any suggestion? Thanks. Ana |
2 answers
I forgot to mentioned that I installed the SQuirreL SQL tool to try to connect to the same JAZZ DERBY database.
I was able to successfuly loign. The DB alias is configured as follow: Drive: Apache Derby Embedded URL: jdbc:derby:C:\RTC\server\repositoryDB |
Hi Ana,
Just so I'm clear on what you're trying to do, you're trying to access operational data from the *repository* using JDBC? This is not a supported scenario, and even if you could get connected, I wouldn't know where to start to tell you where to find the data you're looking for. Our database schemas aren't API, and you'll find that the column and table names may differ from one database type to another. That means even if you were successful in getting the data you wanted from the work items, you'd succeed only in building a Derby-specific report that would never work on Oracle, DB2 or SQL Server, and would likely break as we change our storage mechanisms. james Jazz Reports Team Lead agiordano wrote: I need to create reports that include custom attributes, I do not want |
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.