Re: JPA + Postgres = autocommit?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JPA + Postgres = autocommit?
Date: 2016-07-25 21:53:01
Message-ID: fbca3a7e-c460-e537-fb1c-e23b74ed3020@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 7/25/2016 2:48 PM, rob stone wrote:
> I know nothing about Payara, etc. but the "traditional" way of handling
> this in an application is to:-
>
> BEGIN;
>
> Do your inserts/updates etc.
>
> COMMIT; or if you caught any errors during the inserting/updating, then
>
> ROLLBACK;

Not in Java/JDBC applications. Rather, they have the concept of
autocommit on/off, you configure it on a per connection basis.
commit() and rollback() are API calls to the java database connection
object.

the real question here is how you convince the OP's stack of tools to
disable autocommit, and that I can't help with, but I'm sure its some
field in one of those XML files

--
john r pierce, recycling bits in santa cruz

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message rob stone 2016-07-25 22:48:21 Re: JPA + Postgres = autocommit?
Previous Message rob stone 2016-07-25 21:48:19 Re: JPA + Postgres = autocommit?