DataSet Java Event Handler and use of a single mysql db instance

frenchGuy

Hi!
I would like to create a dynamically datasets with a java class which extends the datasetAdapter class :
-Extraction of data with several queries from MySQL database in beforeOpen method
-Filling of dataset rows in onFetch method.
I used to perform these action in javascript with the methods open and fetch but I prefer to group all my event handling in java classes instead of using javascript in different locations of my reports.

My problem is that I would like to retrieve the database instance from the datasource that I have defined with a connection profile. Is it possible to do so?
If I have 10 datasets defined, do I have to open and close a new DB connection in each dataset or can I retrieve the connection instance from the datasource?
- Does the datasource serve only to set the database connection parameters? In this case how can I retrieve these parameters?
- Or does it create the connection? Can I use these DB connection to create statements and execute mysql queries in the dataset?

Thanks for your help

--
BIRT version : 2.3.1

frenchGuy

I think that I have to create a scripted datasource and a scripted dataset, but the problem is the same. Can I create the DB connection only once or do I have to open and close the connection it in each dataset. If you have a tutorial of how to create a DB connection from a connection profile in Java, it would be really helpfull for me
Thanks!