Grails Birt report plugin - deploying reports

Hi, 
 
Recently I installed STS and tried to deploy my birt report into grails application (within Birt plugin for Grails). I used birt-report-test example from <a class='bbc_url' href='http://grails.org/plugin/birt-report'>Grails Birt plugin</a>. After trying to show my custom report with a chart binded to csv data file I get the >>Cannot open flat file database under directory: null<< message. 
 
How should I resolve this problems since deploying report in Birt viewer on tomcat works fine. I have my_csv.csv file in the same folder as where reports are deployed. I have tried also creating subfolder but without any success. 
 
Should i specify some additional dependencies maybe ? 
 
Data Source code in .rptdesign: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'><oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="example" id="1943">
<property name="URI">my_csv.csv</property>
<property name="DELIMTYPE">COMMA</property>
<property name="CHARSET">UTF-8</property>
<property name="INCLCOLUMNNAME">YES</property>
<property name="INCLTYPELINE">YES</property>
<property name="TRAILNULLCOLS">NO</property>
</oda-data-source></pre>

Find more posts tagged with

Comments

mwilliams

I've not used grails, so I don't know if I'll be much help, but maybe you need to include more in the file path. Maybe the root folder is different? I'll try to look a little deeper into it and let you know if I find anything. Hopefully someone with Grails experience can comment!

bkabka

I was thinking about different root also but this report integration inside grails web app counfuses me with folder structure and where the resources from Birt report should be in (also for css files and other resources which report has with).

I ll try to look some more about it tomorrow since i am unable to reach my grails environment atm.

Thanks in advance for any help

mwilliams

Any luck? Does the full path to the CSV work?

bkabka

I tried to modify the design's xml property 
 
<pre class='_prettyXprint _lang-auto _linenums:0'><oda-data-source extensionID="org.eclipse.datatools.connectivity.oda.flatfile" name="example" id="72">
<property name="URI">c:/my_csv.csv</property></pre>
 
And also few other options but without any impact on the error throwed: 
 
Chart (id = 1566): 
+ An exception occurred during processing. Please see the following message for details: 
Cannot open the connection for the driver: org.eclipse.datatools.connectivity.oda.flatfile. 
org.eclipse.datatools.connectivity.oda.OdaException: Cannot open flat file database under directory: null (Element ID:1566)

mwilliams

What are your BIRT and Grails versions? I might have to try setting it up, if I have time, to see if I have the same issue. You might look into whether there's a resource folder setting that needs to be set.

bkabka

Sorry for a late reply but I had some other things to work with...

Grails: 2.1.1
Spring Tool Suite (Grails): 3.1.0.RELEASE
Eclipse: Indigo Service Release 2
Birt Framework: 4.2.1

mwilliams

Alright. Let me see what I can do. If I get something set up and working, I'll let you know!