Re: JPA + Postgres = autocommit?

Hello Vladimir,

we do use a Payara data source, in that we configure the connection in Payara’s domain.xml. And no, it does not work, at least in the release that we are using (4.1.1.161). If I, however, in my code do the following:

Connection con = entityManager.unwrap(Connection.class);
con.setAutoCommit(false);

then everything works fine.

This is why I said in my mail, that this might be actually a Payara bug.

Best regards,
Yuriy

Von: Vladimir Sitnikov [mailto:sitnikov(dot)vladimir(at)gmail(dot)com]
Gesendet: Dienstag, 26. Juli 2016 13:22
An: Davygora, Yuriy <Yuriy(dot)Davygora(at)sulzer(dot)de>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Betreff: Re: [JDBC] JPA + Postgres = autocommit?

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
________________________________

Sulzer GmbH
Geschäftsführende Gesellschafter: Dr. Johann Sulzer, Albert Euba, Thomas Kahabka
Geschäftsführer: Angelika Rudolph, Harald Lothspeich
Sitz und Registergericht: Stuttgart HRB 7608
http://www.sulzer.de