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