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
Using data source to run two queries or create connection using pojo?
Migrateduser
Hi,
I'm new to BIRT and relatively new to JAVA and I'm trying to come up to speed in BIRT. Here is the background for my question. In java I created a standalone program that connects to a database runs two queries to obtain two results and then maps the result sets to two distinct hashmaps and eliminates duplicates between the two hashmaps. I'm now attempting to implement this in BIRT. Here is my question using BIRT's interface can I create a datasource--connection to the database and then use that connection to script the running of the queries/hashmap etc.. Or do I have to leave/make the connection creation in pojo creating java jar file? It would seem like you could create the connection/datasource in BIRT and then script the execution of the queries and processing of the result sets. But I've been unable to find an example of this. So far I see examples for running a simple query data source/data set and linking it to a table field on the report or the discussion moves to scripted data sources--where I assume you make the connection in the pojo creating java code. Thanks in advance for any advice.
Find more posts tagged with
Comments
There are no comments yet