ERROR: cannot execute CREATE TABLE in a read-only transaction

Hi there.

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.

JasperStudio 6.3.0


db2907's picture
Joined: Jul 7 2016 - 6:53am
Last seen: 3 years 6 months ago

0 Answers:

No answers yet