I can connect to the PostgreSQL database with 'jdbc:postgresql://xxx:5432/yyy' but every query gives this error. org.postgresql.util.PSQLException: Cannot establish a savepoint in auto-commit mode.
In version 2015.10 it worked fine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
View and moderate all "Technical questions" comments posted by this user
Mark all as spam, and block user from posting to "Discussion"
I can connect to the PostgreSQL database with 'jdbc:postgresql://xxx:5432/yyy' but every query gives this error.
org.postgresql.util.PSQLException: Cannot establish a savepoint in auto-commit mode.
In version 2015.10 it worked fine.
Please go in preferences and set Auto-commit off to be able to use Auto-savepoint in transactions.
starting with 2016.01 it will be possible to choose between Auto-commit and Auto-savepoint
see ticket #337
Regards
PAscal
in monetDB, the corresponding error message is:
java.sql.SQLException: SAVEPOINT: not allowed in auto commit mode.