update query in birt

sandeepBha

hi all,

i want to know that can i update a column in database from birt.

in dataset there are only two option one for 'SELECT' and second for 'STORED PROCESURE '

please help soon

sandeep

Virgil Dodson

Hi sandeep,

Generally, BIRT is used to read and display data from a database... however, BIRT can run Java or JavaScript during the report execution and rendering processes. This means you can do things like establish your own JDBC connection and update/insert into a database. An example is enclosed that updates a counter in the database each time a report is run. This example uses server-side JavaScript in the report initialize script method.

You could also run a stored procedure from BIRT which can do some updates from the database side.