I have an adhoc view with date filter in jasper 6.0. I imported that to another instance of jasper 6.1 and the date filter stopped affecting the adhoc view.
Looking at the adhoc cache, I found out that in v.6.0 my query in jasper used to be and ("PO_DATE" > TIMESTAMP '2015-08-12 00:00:00')
while in v.6.1 it's and ("PO_DATE" > '2015-08-12 00:00:00') that's why the error.
My database is Oracle and I checked the semantics file in 6.1, mapping of date is correctly set to java.util.date
What could be the problem?