If I try to add the datasource to the library (commented out below) I get:
org.eclipse.birt.report.model.api.command.ContentException: The ODA Data
Source("Runtime Data Source") is not allowed directly or indirectly
inside the Library's slot(dataSources).
If I add the datasource to the report it works but I get an exception
when changing the datasource of the datasets:
IllegalOperationException: The module is read-only and operation is
forbidden.
Is there a simpler approach all together?
----------------------------------------------------
String dataSourceName = "Runtime Data Source";
ElementFactory designFactory =
this.currentReport.getDesignHandle().getElementFactory();
OdaDataSourceHandle dsHandle =
designFactory.newOdaDataSource(dataSourceName,
"org.eclipse.birt.report.data.oda.jdbc");
dsHandle.setProperty("odaDriverClass", "org.sqlite.JDBC");
dsHandle.setProperty("odaURL", this.databaseURL);
LibraryHandle library = (LibraryHandle)
currentReport.getDesignHandle().getModuleHandle().getLibraries().get(0);
currentReport.getDesignHandle().getModuleHandle().getDataSources().add(dsHandle);
// library.getDataSources().add(dsHandle); // Exception on this line if
swapped for the above line
// update ALL datasets
SlotHandle slotHandle = library.getDataSets();
for (Iterator i = slotHandle.iterator(); i.hasNext();) {
DataSetHandle dataSetHandle = (DataSetHandle) i.next();
dataSetHandle.setDataSource(dataSourceName); //Exception on this line
}
Jason Weathersby wrote:
Anthony,
can you post the code you used to do this?
Jason
Anthony wrote:
Actually, the workaround via the API - adding a datasource at
runtime, and setting it as the source for each dataset - doesn't
work, since the datasets and datasource are in a library - you get an
exception:
org.eclipse.birt.report.model.api.IllegalOperationException: The
module is read-only and operation is forbidden.
Anthony
Anthony wrote:
In the library I have the datasource, and the parameter, and the
property binding is set there in the Edit Data Source -> Property
Binding screen.
Report parameter binding in datasets in the library *does* seem to
work if I hard code the datasource, so I believe the problem is with
the datasource.
I can display the parameter values in a dynamic text field just fine
so I know they are being passed into the report.
It doesn't seem to make any difference if the parameters are also in
the Report (rather than just in the library) - I'm not sure whether
or not they should be?
I believe this *does* worked in some cases, so perhaps there is some
other condition triggering this.
Anthony
Jason Weathersby wrote:
Anthony,
I tried this with BIRT 2.3.1 and it worked for me. Do you have the
parameter and the ds in the library and did you set the property
binding in the lib?
Jason
Anthony wrote:
Changing a datasource URL at runtime is trivial using property
binding and report parameters (e.g. params["runtimeURL"].value).
However this doesn't seem to work when the datasource is in a
library - the parameters are ignored, and the defaults are used.
So I have two questions
1) How can I change the JDBC driver URL of a datasource once the
report is loaded as IReportRunable? Or can I only do it by
creating a new datasource and updating all the datasets to
reference it?
2) Is there a way to get this to work with property binding and
report parameters? Or is it not possible to use libraries to
share datasources that need to be changed at runtime?
https://bugs.eclipse.org/bugs/show_bug.cgi?id=154189 makes it look
like it's not.