Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » How to reuse datasource by scripting?
How to reuse datasource by scripting? [message #239688] Thu, 24 May 2007 06:42 Go to next message
mr. burns is currently offline mr. burnsFriend
Messages: 402
Registered: July 2009
Senior Member
Hello,

I created a report with JDBC datasource. Now I not only want to use the
datasource for the dataitems (tables, etc.) but also by scripting to do SQL
queries to same database but different tables. How can I reuse the
datasource of the report for my own SQL queries?

I need something like:

conn = reportContext.getConnection();
st = conn.CreateStatement();

sql = "select * from myTable where ...

st.execute(sql);
....

How can I access the database using scripting and SAME datasource as I
defined in my report?

Thanks for any help!
Re: How to reuse datasource by scripting? [message #240138 is a reply to message #239688] Tue, 29 May 2007 11:17 Go to previous messageGo to next message
mr. burns is currently offline mr. burnsFriend
Messages: 402
Registered: July 2009
Senior Member
Hello,

I still need help, can anyone support me please?

Thanks a lot!
Re: How to reuse datasource by scripting? [message #242491 is a reply to message #239688] Wed, 13 June 2007 13:13 Go to previous messageGo to next message
mr. burns is currently offline mr. burnsFriend
Messages: 402
Registered: July 2009
Senior Member
Hello?

I still need help!

Thanks!
Re: How to reuse datasource by scripting? [message #1799311 is a reply to message #242491] Tue, 04 December 2018 15:01 Go to previous message
Alexander Wieland is currently offline Alexander WielandFriend
Messages: 5
Registered: November 2017
Junior Member
Hello,

did you solve the problem you had? If so, do you remember how you did it? I already have a Java class to which I want to pass the connnection, which then makes the query in the database. Now all I need is the database connection used in BIRT. But I just can't find a solution to how this is done in BIRT.

Thanks for your help in advance.

Many greetings
Alex
Previous Topic:No Page break on last page
Next Topic:Update Table column
Goto Forum:
  


Current Time: Sat Jul 20 15:53:48 GMT 2019

Powered by FUDForum. Page generated in 0.01519 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top