Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Executing arbitrary SQL in event scripts
Migrateduser
Before switching to BIRT, we were using Oracle Reports. A very nice feature of that product is the ability to execute SQL and PL/SQL inside triggers (=events in BIRT).
I developed a plugin to enable this in BIRT as well.
While this is working very well (including bind variables), it has two major drawbacks:
* It uses a dirty hack (Reflection API) to access the actual JDBC Connection of a ODA JDBC Data Source.
* It only works if the JDBC Data Source is already open, e.g. if one of the Data Sets using the Data Source has already been accessed from the layout. This means I can not use SQL in the beforeFactory event.
So what I'd like to know:
Is it possible to to test if an ODA JDBC Data Source is already open (connected to the DB) from a script and to open it in case it's not?
I would like to donate the code to the community if someone would eliminate the two problems given above and include it into the Open Source Eclipse BIRT release.
Find more posts tagged with
Comments
There are no comments yet