On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.

BIRT Report with database write-back

pricher
edited 2013 01 in DevShare Downloads #1
This is an example of using a servlet to write-back data from a BIRT report to a database.<br />
<br />
The servlet uses a copy of ClassicModels for SQL Server, but it could be adpated to any RDBMS.<br />
Once the servlet is compiled and jarred, put the jar file in your iportalWEB-INFlib folder. Then, modify your web.xml file to add the following entries and re-start iPortal:
&lt;&gt;
 &lt;servlet&gt;
  &lt;servlet-name&gt;BirtWriteBack&lt;/servlet-name&gt;
  &lt;servlet-class&gt;com.actuate.aces.servlet.BirtWriteBack&lt;/servlet-class&gt;
 &lt;/servlet&gt;
 &lt;&gt;
 &lt;servlet-mapping&gt;
  &lt;servlet-name&gt;BirtWriteBack&lt;/servlet-name&gt;
  &lt;url-pattern&gt;/servlet/BirtWriteBack&lt;/url-pattern&gt;
 &lt;/servlet-mapping&gt;

<br />
The report design uses the new A10 HTML button to update one row of the report. The JavaScript code to call the servlet is in a text item at the top of the report.