Collection always contains strings...

[stelek]

Hi,

I have just created my first report with possibility of choosing values of input parameters based on an SQL query. To do that, I added java.util.Collection parameters and then used the $X syntax in the main query. I configured it on the Jasper Server and it works just fine there. Everything is just as I expected...

...but not in iReport. When I try to run the report from iReport, the editor asks me for the parameter values. Since my parameters are compared to integer values in the database I enter: 1, 2 in the window that pops up. I confirm and a moment later I get a SQL error: "operator does not exist: integer = character varying". I analyzed the problem and it seems that iReport is always producing a collection of strings instead of my expected collection of integers. So when I enter: 1,2 and expect to have [1,2] I actually get ["1","2"]. Is there anything I can do about it?

The problem is really non-existant on the Jasper Server where a proper collection of integers is created. It just does not work in iReport.

iReport 3.5.3