I'm facing this annoying problem in Jasper. I have created a report based on a postgresql function. When I watch the preview I do not have any problem with the results. However, when I publish the report and try to executing I'm getting this error:
org.postgresql.util.PSQLException: ERROR: cannot execute CREATE TABLE in a read-only transaction
I've checked on internet for a possible solution, so far this is the only thing that I have found with a similar problem:
However adding the property to Url does not work, or I'm not so sure if I have to write it in this way:
In Jasper what else can I do?. I only can query the function, and require any change in it is an HUGE burocratic issue.