: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
t; 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.
>>&g
> 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.
&g
ection 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 Datab
T=DEFAULT
> 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
ssage,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 :
in 2022 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.s
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 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
date,logger,level,message,exception,pid,idUtilisa