:22:26 PM
An: Commons Users List
Betreff: Re: DBCP Database Connection Pools without transactionnal NO autocommit
Any news?
Gary
On Thu, Jun 2, 2022 at 12:32 PM Gary Gregory wrote:
>
> BTW, if that still does not work for you, make sure your are using the latest
> version of DBCP an
tId,sqlTimeMillis)
>>> > values (... the values ...)
>>> > commit
>>> >
>>> > Also before returning the connection to my log4j2 Async Appenders
>>> > whith ConnectionFactory, I force : connection.setAutoCommit(false);
>>> > But res
In code call :
>> org.apache.logging.log4j.Logger.trace("hello")
>>
>> Finally calling logger,
>> use JDBC Appender
>> and get a connection from the BasicDataSource pool.
>> And continu outside my code with the unwanted transactional statement.
>
n from the BasicDataSource pool.
> And continu outside my code with the unwanted transactional statement.
> For writing log in my database.
>
> -Message d'origine-
> De : Gary Gregory
> Envoyé : jeudi 2 juin 2022 11:23
> À : Commons Users List
> Objet : Re: DBCP Database Con
insert into log4j2
>
> (date,logger,level,message,exception,pid,idUtilisateur,version,ip,mark
> erSimpleName,sqlLastInsertId,sqlTimeMillis)
> values ...
> commit
>
> Cheers.
>
>
> -Message d'origine-
> De : Gary Gregory Envoyé : mercredi 1 juin
> 2022 1
,exception,pid,idUtilisateur,version,ip,markerSimpleName,sqlLastInsertId,sqlTimeMillis)
> values ...
> commit
>
> Cheers.
>
>
> -Message d'origine-----
> De : Gary Gregory
> Envoyé : mercredi 1 juin 2022 14:57
> À : Commons Users List
> Objet : Re: DBC
22 14:57
À : Commons Users List
Objet : Re: DBCP Database Connection Pools without transactionnal NO
autocommit
Hello,
Try calling Connection#setAutoCommit(false) once you get a Connection.
You'll likely want to configure your data source with
org.apache.commons.dbcp2.BasicDataSource.setAuto
Hello,
Try calling Connection#setAutoCommit(false) once you get a Connection.
You'll likely want to configure your data source with
org.apache.commons.dbcp2.BasicDataSource.setAutoCommitOnReturn(false)
to avoid resetting the auto-commit flag.
Gary
On Tue, May 31, 2022 at 7:46 PM Sébastien
