Relative path to .csv data source with tomcat

Vex

Hello all!

I have a slight problem with Birt Web Viewer and Tomcat (5.5).
I've copied the WebWieverExample from the birt-runtime in the tomcat webapps folder (according to the instructions) and the test report works fine.

However, when I try to run my report (which uses a csv text file as a data source), I get an exception due to the wrong path to the data source ("Cannot open flat file database under directory: util").

Here's the snippet from the .rptdesign file:

<data-sources>
<oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="Data Source" id="61">
<property name="HOME">util</property>
<property name="DELIMTYPE">COMMA</property>
<property name="CHARSET">UTF-8</property>
<property name="INCLCOLUMNNAME">NO</property>
<property name="INCLTYPELINE">NO</property>
</oda-data-source>

The report is in the root of the application, and the folder named "util" (and inside the data set file) is present. I've tried all path variations in the "HOME" parameter I can think of, but to no avail. When I type in the absolute path, it works.

What am I doing wrong?

JasonW

One way of handling this is to get the full path dynamically using a beforeOpen script on the datasource like:

if( reportContext.getHttpServletRequest().getAttribute("attributeBean").isDesigner() ){
testvar = "Designer";
}else{
var rp = reportContext.getHttpServletRequest().getSession().getServletContext().getRealPath("/csvfile");
if( rp == null ){
testvar="cant find reports";
}else{

testvar = rp;
this.setExtensionProperty("HOME", rp);
}
}

Where csvfile is the directory containing the csv file.

Jason