| Extend the JDBC Datasource? [message #252916] |
Fri, 17 August 2007 14:28  |
Eclipse User |
|
|
|
I'm trying to figure out how best to create a new type of data set.
Basically, I want to reuse the JDBC data source for specifying the
driver, db, user, etc., but I want a different type of data set that
doesn't require the user to input SQL. My data set will specify the
select statement, I just want the user to enter some (non-trivial)
parameters that fit into the SQL.
What's the best way to do this?
I am reading "Integrating and Extending BIRT" and the section on
creating an ODA data source is really interesting, but it doesn't seem
that you can extend the org.eclipse.birt.report.data.oda.jdbc plugin.
Thanks for any help!
Cheers,
Craig
|
|
|
| Re: Extend the JDBC Datasource? [message #252924 is a reply to message #252916] |
Fri, 17 August 2007 17:58  |
| Eclipse User |
|
|
|
Craig,
It depends on how much of the existing code that you'd want to reuse.
It sounds like you want to provide mostly own data set UI page
implementation, and reuse its data source UI pages. And perhaps just some
minor extension to the oda.jdbc runtime driver?
If the above are what you need, you can create your own oda.jdbc.ui plugin,
and change/add an oda data set extension to point to your own UI
implementation. You may also optionally remove the original oda.jdbc.ui
plugin from the installation to avoid having 2 similar jdbc data sources.
For extension to the oda.jdbc runtime driver, you can keep the original
oda.jdbc plugin, and implement the
org.eclipse.datatools.connectivity.oda.consumer.driverBridge extension point
to add on any additional behavior. Such extension would basically intercept
any calls made to the ODA runtime interfaces of any specified ODA driver.
Linda
"Craig L. Ching" <cching@mqsoftware.com> wrote in message
news:fa4pc6$4lc$1@build.eclipse.org...
> I'm trying to figure out how best to create a new type of data set.
> Basically, I want to reuse the JDBC data source for specifying the driver,
> db, user, etc., but I want a different type of data set that doesn't
> require the user to input SQL. My data set will specify the select
> statement, I just want the user to enter some (non-trivial) parameters
> that fit into the SQL.
>
> What's the best way to do this?
>
> I am reading "Integrating and Extending BIRT" and the section on creating
> an ODA data source is really interesting, but it doesn't seem that you can
> extend the org.eclipse.birt.report.data.oda.jdbc plugin.
>
> Thanks for any help!
>
> Cheers,
> Craig
|
|
|
| Re: Extend the JDBC Datasource? [message #252988 is a reply to message #252924] |
Mon, 20 August 2007 10:56 |
| Eclipse User |
|
|
|
Linda Chan wrote:
Hi Linda,
> Craig,
>
> It depends on how much of the existing code that you'd want to reuse.
> It sounds like you want to provide mostly own data set UI page
> implementation, and reuse its data source UI pages. And perhaps just some
> minor extension to the oda.jdbc runtime driver?
> If the above are what you need, you can create your own oda.jdbc.ui plugin,
> and change/add an oda data set extension to point to your own UI
> implementation. You may also optionally remove the original oda.jdbc.ui
> plugin from the installation to avoid having 2 similar jdbc data sources.
>
> For extension to the oda.jdbc runtime driver, you can keep the original
> oda.jdbc plugin, and implement the
> org.eclipse.datatools.connectivity.oda.consumer.driverBridge extension point
> to add on any additional behavior. Such extension would basically intercept
> any calls made to the ODA runtime interfaces of any specified ODA driver.
>
Ok, I'll have to look into those, thanks for that! Ideally, all I
really want to do is keep the existing JDBC Data Source UI and
everything that goes with the JDBC connection information, but add a new
value to the drop down box when creating a data set (i.e. the drop down
box that lets you select SQL query or SQL stored procedure).
> Linda
>
Cheers,
Craig
|
|
|
Powered by
FUDForum. Page generated in 0.02985 seconds
Home