RE: DBCP Database Connection Pools without transactionnal NO autocommit

2022-06-02 Thread Sébastien Jachym
: Re: DBCP Database Connection Pools without transactionnal NO autocommit 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

RE: DBCP Database Connection Pools without transactionnal NO autocommit

2022-06-01 Thread Sébastien Jachym
CommitOnReturn(false) to avoid resetting the auto-commit flag. Gary On Tue, May 31, 2022 at 7:46 PM Sébastien Jachym wrote: > > Hy, is a way to fully disabled transactional (autocommit) statement in > DBCP ? > > > > Using Database Connection Pools with > org.apache.comm

DBCP Database Connection Pools without transactionnal NO autocommit

2022-05-31 Thread Sébastien Jachym
Hy, is a way to fully disabled transactional (autocommit) statement in DBCP ? Using Database Connection Pools with org.apache.commons.dbcp2.BasicDataSource give me statements : SET autocommit=1 SET autocommit=0 SET SQL_SELECT_LIMIT=1 select