Using BIRT 2.2.2 Viewer within Apache Tomcat 6.0

alwan

I am new To BIRT and Apache Tomcat and managed to use BIRT viewer to show a report and passing some parameters from the user with the javaServer page.

The problem is that the dataset is cached, so if the database is changed, the shown data is from the old database.

This is part of the javaServer page:

<form action="http://****:8082/birt-viewer/frameset?&quot; method="post"
name="User" onsubmit="return checkform(this);" >
<input type="hidden" name="__report" value="report/myreport.rptdesign" />
<input type="hidden" name="__showtitle" value="false" />
<input type="hidden" name=" __overwrite" value="true" />
<input type="hidden" name="__parameterpage" value="false" />
<input name="CompanyName" type="text" maxlength="25" size="25" />
<input type="submit" value="Search">
</form>


Within Eclipse, the report shows the correct data from the new database, but if I copied myreport.rptdesign to $(Program Files) Tomcat 6.0webappsbirt-viewerreport then it does not show the same result as with Eclipse even if I restart Tomcat and delete $(Program Files) Tomcat 6.0webappsbirt-viewerdocumentsmyreport.rptdocument.

I am using Microsoft JDBC driver for my SqlServer database.