I have created a simple SOAP Axis2 Web service with JasperReports Libraries. Using iReport designer I created simple report which selects fields from a VIEW in my database. It works perfectly in designer(select all the needed data), but when I try to compile it with libraries I get:
Error executing SQL statement for : Report1
This bug happens only with VIEW's. So it took me 1 day to figure this out. In my view select i used division and multiplication with varchar2 and i think iReport,pl/sql developer automatically casted it into number but the libraries couldn't.