BIRT Report with database write-back

pricher

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:

<>
 <servlet>
  <servlet-name>BirtWriteBack</servlet-name>
  <servlet-class>com.actuate.aces.servlet.BirtWriteBack</servlet-class>
 </servlet>
 <>
 <servlet-mapping>
  <servlet-name>BirtWriteBack</servlet-name>
  <url-pattern>/servlet/BirtWriteBack</url-pattern>
 </servlet-mapping>

<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.