Re: DBCP Database Connection Pools without transactionnal NO autocommit

2022-06-02 Thread Gary Gregory
BTW, if that still does not work for you, make sure your are using the latest version of DBCP and of your JDBC Driver. Please report which versions you are using. If you are still stuck, the only way we can realistically help you here is if you provide a PR with a reproducible test case using the

RE: DBCP Database Connection Pools without transactionnal NO autocommit

2022-06-02 Thread Sébastien Jachym
I'm logging with log4j2 log4j2.xml : ... ConnectionFactory class : public static Connection getConnection() throws SQLException { dataSource = new org.apache.commons.dbcp2.BasicDataSource();

Re: DBCP Database Connection Pools without transactionnal NO autocommit

2022-06-02 Thread Gary Gregory
It might be simpler to avoid custom Java code. Is there a reason you are not using the log4j2-jdbc-dbcp2 module? For example https://github.com/apache/logging-log4j2/blob/release-2.x/log4j-jdbc-dbcp2/src/test/resources/log4j2-jdbc-dbcp2.xml Gary On Thu, Jun 2, 2022, 08:13 Sébastien Jachym <

Re: DBCP Database Connection Pools without transactionnal NO autocommit

2022-06-02 Thread Gary Gregory
Something is not clear to me: are you in control of calling JDBC or are you using Log4j's JDBC Appender or something else? You description is not detailed enough for me to understand who does what. Gary On Wed, Jun 1, 2022, 19:49 Sébastien Jachym < sebastien.jac...@agri-commerce.fr> wrote: >