As some of you may have noticed, executing sql statements like this "SET LOCAL TimeZone='Pacific/Enderbury'; SELECT NOW() AT TIME ZONE (SELECT current_setting('TIMEZONE')) ;" is not possible. Rendering reporting of jasper almost useless accross multiple time zones and user queries (at least in our situation).
As jdbc offers transaction processing by disabling the default set auto-commit. I guess applying this to jasperreports queryexecuter could solve this problem.
Does any one have any information on what the best approach would be to implement this? Why didnt jasper developers implement it this way, in the first place? Is this not as easy as it looks like?