Re: JPA + Postgres = autocommit?

On 25.07.2016 09:54, Davygora, Yuriy wrote:
> And here is an excerpt from the Payara domain.xml:
>
> *<jdbc-connection-pool
> datasource-classname="org.postgresql.ds.PGSimpleDataSource"* name="PDMDataSource" res-type="javax.sql.DataSource">
> Am I missing something here? How do I disable the autocommit? Any help would be greatly appreciated.
>
IMO this part in bold is your problem i.e. the setting of DataSource
class name. I've checked the documentation for PGSimpleDataSource
(https://jdbc.postgresql.org/documentation/publicapi/org/postgresql/ds/PGSimpleDataSource.html)
and there is the following explanation:

Simple DataSource which does not perform connection pooling.

Please note that I don't have experience with Payara/Eclipselink. Maybe
you should use some of the other DataSource implementations in
PostgreJDBC or configure dedicated connection pool like c3p0.

--
Поздрави, | Best regards,
Радослав Петров | Radoslav Petrov