pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17075: Cannot commit when autoCommit is enabled
3+ messages / 3 participants
[nested] [flat]
* BUG #17075: Cannot commit when autoCommit is enabled
@ 2021-06-28 15:14 PG Bug reporting form <noreply@postgresql.org>
2021-06-28 15:43 ` Re: BUG #17075: Cannot commit when autoCommit is enabled Julien Rouhaud <rjuju123@gmail.com>
2021-06-28 15:51 ` Re: BUG #17075: Cannot commit when autoCommit is enabled David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: PG Bug reporting form @ 2021-06-28 15:14 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: dhanabakeeswari15@gmail.com
The following bug has been logged on the website:
Bug reference: 17075
Logged by: dhanabakeeswari v
Email address: dhanabakeeswari15@gmail.com
PostgreSQL version: 11.12
Operating system: Red Hat Enterprise Linux Server (7.8 version)
Description:
I am facing the "Cannot commit when autoCommit is enabled: " issue in the
application level.
I need to disable the auto-commit in the DB level for permanently.
Please help me to solve this
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17075: Cannot commit when autoCommit is enabled
2021-06-28 15:14 BUG #17075: Cannot commit when autoCommit is enabled PG Bug reporting form <noreply@postgresql.org>
@ 2021-06-28 15:43 ` Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Julien Rouhaud @ 2021-06-28 15:43 UTC (permalink / raw)
To: dhanabakeeswari15@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Mon, Jun 28, 2021 at 11:34 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
>
> I am facing the "Cannot commit when autoCommit is enabled: " issue in the
> application level.
> I need to disable the auto-commit in the DB level for permanently.
> Please help me to solve this
This message isn't coming from postgres. After a quick search it
seems that this is coming from jdbc. In any case, the message is
clear, and is due to a bad usage of the driver.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17075: Cannot commit when autoCommit is enabled
2021-06-28 15:14 BUG #17075: Cannot commit when autoCommit is enabled PG Bug reporting form <noreply@postgresql.org>
@ 2021-06-28 15:51 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: David G. Johnston @ 2021-06-28 15:51 UTC (permalink / raw)
To: dhanabakeeswari15@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Mon, Jun 28, 2021 at 8:34 AM PG Bug reporting form <
noreply@postgresql.org> wrote:
> I need to disable the auto-commit in the DB level for permanently.
>
PostgreSQL does not provide a knob to enable/disable this. If you don't
use an explicit BEGIN your command will commit as soon as it successfully
executes (and will rollback immediately if there is a failure). As Julien
said, though, your driver may be doing stuff above and beyond the SQL
commands you yourself send. Proper usage of you chosen driver/library is
outside the scope of the general PostgreSQL mailing lists (and in any case
this report does not constitute a bug report).
At least, unless you are using libpq directly or somehow manage to get this
to happen in psql.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-06-28 15:51 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-28 15:14 BUG #17075: Cannot commit when autoCommit is enabled PG Bug reporting form <noreply@postgresql.org>
2021-06-28 15:43 ` Julien Rouhaud <rjuju123@gmail.com>
2021-06-28 15:51 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox