Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Storing data in database directly from the report(How to update database with results calculated in the report)
Storing data in database directly from the report [message #517618] Mon, 01 March 2010 14:41 Go to next message
Dariusz Filipski is currently offline Dariusz FilipskiFriend
Messages: 10
Registered: July 2009
Junior Member
Hi,

Is there a possibility (and if yes - any samples, links or hints?) to execute insert or update queries on some database directly from the report after generation? It may require some additional classed, of course. What I want to achieve is to store some calculations' results from heavy reports and use them in other reports. Ideally I would like to retrieve database connection directly from some data source, so it's wouldn't require separate connection definition (but it's, of course, not necessary, any insert/update possibility would do).

Cheers,
Darek
Re: Storing data in database directly from the report [message #517672 is a reply to message #517618] Mon, 01 March 2010 16:22 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Darek,

Re-using the connection can be problematic. If you passed in the
connection it should be easy to reuse. To implement the insert you need
to create a Java or JavaScript handler in the afterFactory event and
have it make the connection, insert, and close the connection. Take a
look at the scripting page for details on event handlers.

http://www.eclipse.org/birt/phoenix/deploy/reportScripting.p hp

Jason

Dariusz Filipski wrote:
> Hi,
>
> Is there a possibility (and if yes - any samples, links or hints?) to
> execute insert or update queries on some database directly from the
> report after generation? It may require some additional classed, of
> course. What I want to achieve is to store some calculations' results
> from heavy reports and use them in other reports. Ideally I would like
> to retrieve database connection directly from some data source, so it's
> wouldn't require separate connection definition (but it's, of course,
> not necessary, any insert/update possibility would do).
>
> Cheers,
> Darek
Previous Topic:BIRT 2.5 javadoc API online ?
Next Topic:Debug org.eclipse.birt.report.engine.emitter.csv plugin
Goto Forum:
  


Current Time: Fri Apr 26 05:30:55 GMT 2024

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

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

Back to the top