| From: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
|---|---|
| To: | "Davygora, Yuriy" <Yuriy(dot)Davygora(at)sulzer(dot)de> |
| Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: JPA + Postgres = autocommit? |
| Date: | 2016-07-26 11:22:04 |
| Message-ID: | CAB=Je-HM119fW9s0MAT2L7hRL-HPwwEwyROFzQuTeW=XvPdMeA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Yuriy>1. In PgConnection.java, the autocommit is initially set to
true in the declaration (private boolean autocommit = true). In the
constructor of the PgConnection class, several options are checked
(PGProperty), but there is none that has to do with autocommit. Thus,
unless, the client explicitely calls setAutoCommit(false), it will remain
true.
Just for the reference, the specification (see Connection#setAutoCommit
javadoc) states that "By default, new connections are in auto-commit mode"
Yuriy>We are using a JTA data source and the transactions are managed by
the JEE container
Why don't you use Payara's data source then?
It should solve the problem as Payara seems to have some setAutoCommit
logic:
https://github.com/payara/Payara/search?utf8=%E2%9C%93&q=setautocommit
Vladimir
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Davygora, Yuriy | 2016-07-26 11:51:19 | Re: JPA + Postgres = autocommit? |
| Previous Message | Vladimir Sitnikov | 2016-07-26 11:16:02 | Re: JPA + Postgres = autocommit? |