Re: JPA + Postgres = autocommit? - Mailing list pgsql-jdbc

From Vladimir Sitnikov
Subject Re: JPA + Postgres = autocommit?
Date
Msg-id CAB=Je-HcFH8KPZuTrRR=UjOpaG+vs1O70SwmSbcqRWucxiecSg@mail.gmail.com
Whole thread Raw
In response to Re: JPA + Postgres = autocommit?  (Radoslav Petrov <rado@edno.moe>)
List pgsql-jdbc
Radoslav>Maybe you should use some of the other DataSource implementations in PostgreJDBC or configure dedicated connection pool like c3p0.

The advice to use "decent connection pooler" is good (I would recommend Hikari-CP), however it should not matter for "autocomittment" (how would you spell that? :)

Yuriy, can you share test project that reproduces the issue?
You might have missed @Transacted or something like that in your application code.

What is the exact error you are running into?

As far as I understand, the following should happen:
1) DataSource produces connection with any autocommit setting
2) JPA should call con.setAutocommit(false) when it senses the "start of transaction" at the application side

I bet there is no transaction created/enabled at application side.

Vladimir

pgsql-jdbc by date:

Previous
From: "Davygora, Yuriy"
Date:
Subject: Re: JPA + Postgres = autocommit?
Next
From: Vladimir Sitnikov
Date:
Subject: Re: JPA + Postgres = autocommit?