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:

https://community.jaspersoft.com/questions/814793/report-execution-fails-due-read-only-transaction-mode

However adding the property to Url does not work, or I'm not so sure if I have to write it in this way:

jdbc:postgresql://server:5432/data_base?defaultReadOnly="false"


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

Regards.

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

0 Answers:

No answers yet
Feedback
randomness