||Tue, 19 August 2008 18:14
Originally posted by: jasonweathersby.alltel.net|
If you need the specific connection then your best best is to write a
driver bridge plugin. You can get the connection object and make your
call before the default driver calls your dataset. Take a look at this
Your requirement is not connection pooling but the article(s) cover the
driver bridge extension.
Babu Kumar wrote:
> I trying to develop a library for our reports development and I have a
> requirement of calling a stored procedure before the execution of the
> SQL Query. How can I achive this?
> Is it possible to get the underlying connection of the datasource so
> that I can execute the Stored procedure in the afteropen event of the
||Mon, 21 February 2011 13:52
| Jason Weathersby
Registered: July 2009
I am not exactly sure what you are trying to do, but if you want a
stored proc to run before your standard dataset, create one datasource,
then one dataset that calls the proc and one dataset that reads from the
table. Bind a hidden table at the top of the report to stored proc data
set first. Below it bind your second dataset to the second dataset.
On 2/21/2011 11:33 AM, Athul Shetty wrote:
> Hi Jason,
> Could you please explain in detail...we dont want to use connection
> pooling but want to use connection which is created by the report data
> source; curretly using only BIRT viewer to generate the report (wont use
> command line report engine also).
> I have posted similar question in birt-exchange also.
> I have below requirement:
> 1) Have stored procedure testrun(in number) and it will insert into temp
> 2) Design the report to show the data in temp table
> 3) Create the data set like select * from temp table
> How can I call stored procedure before the execution of data set? I am
> currently using "beforeOpen" method to customize the select query but
> NOT finding the way to execute the stored procedure.
> Here select and stoted procedure execution should be seperate; its the
> Could you please help on this?
> Thanks in advance,
> Athul Shetty
Powered by FUDForum
. Page generated in 0.01631 seconds