Passing java.util.Date param through web service

[jmario]

Hi,

i have a problem with java.util.Date parameter that i am passing to the runReport method. The problem is, that the service requires the date parameter in miliseconds to work and i am sending the param in milis, but the report  is still not working fine. I get an error (from the log):

11:22:26,671 ERROR ManagementService,http-8080-Processor17:1205 - caught Throwable exception: Error executing SQL statement for : reportName
com.jaspersoft.jasperserver.api.JSExceptionWrapper:
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : reportName

.....................

 

I am using DateFrom and DateTo params in the SQL statemtent as follows:

AND      [someShema].[DbDate] between $P{DateFrom} and $P{DateTo}

Both params are defined:

    <parameter name="DateFrom" class="java.util.Date">
    </parameter>
    <parameter name="DateTo" class="java.util.Date">
    </parameter>

 

When i run this report from the jasper server admin page or from the ireport directly the report WORKS fine! Only when i call the report from the webService it doesn't - passing xml request!

So the question could be: how configure the reports date params to work in miliseconds? Or how to configure the web service to accept the date param in other format than just in milis ?

 

Thanks in Advance!