How to reuse database connection in BIRT report
I am using Eclipse BIRT designer (4.5v) to develop the report where I need to use both the JDBC Data Source and the Scripted Data Source. I could give the connections details in JDBC data source and establish the database connection successfully. In the Scripted DS open event, I need to use the same database connection to execute the stored procedure. I can use JDBC data source to make the stored procedure call directly but for my requirements, I need to use only the Scripted data source. Any ideas how I can reuse the already established database connection in open event of scripted data source to make the stored procedure call? Any help is appreciated. Thanks.