autocommit=true always set

Description

autocommit=true (conn.setAutocommit(...)) is set every time a connection is pulled from the connection pool or created.

Lucee should make sure that all connections in the pool, have set autocommit=true, that way it is not necessary to check it when taking a connection from pool.

We could also do a flag in the settings of the datasource, where the user can accept the risk that a connection is not true, this could happen when in a cfquery a "SET AUTOCOMMIT=0" is executed.

Environment

None

relates to

Activity

Michael Offner 
20 April 2020 at 08:10

Michael Offner 
20 April 2020 at 07:38

we will add a service that check in an interval all connection within the pool and make sure they have autocommit set to true

Fixed

Details

Assignee

Reporter

Priority

Labels

Fix versions

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Sprint

Created 24 January 2020 at 12:37
Updated 8 May 2020 at 18:32
Resolved 23 April 2020 at 18:03