db2907 Posted October 15, 2018 Share Posted October 15, 2018 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 transactionI'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-modeHowever 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.0Regards. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now