LDEV-396 Breaks Transaction Rollback

Description

Any Lucee version (4.5.xx or 5.xx) after the patch, transactionRollback() doesn't roll anything back and the data persists. With Lucee versions before the patch, rollbacks work fine, but I can trigger the lucee.runtime.db.DCStack bug which locks up Lucee until a restart.

A simple test case is attached which persists data to the database.

Environment

Lucee with Tomcat on Windows 10 and Ubuntu 14
MySQL 5.6 on Windows and Amazon RDS
Using ORM
Lucee 4.5.4.003+
Lucee 5.0.1.10+ with Hibernate extension 3.5.5.xx and 4.3.11.42

Attachments

1

Activity

Michael Offner 
18 July 2017 at 19:35

Mark Summers 
22 November 2016 at 11:36
(edited)

This is a bit of speculation, but wouldn't this problem appear if the default AutoCommit status of the DB connection was changed from false to true?

More simply, isn't it the case that AutoCommit IS the default for many databases, including MySQL, Oracle and SQL Server? This would explain the behaviour seen, if no attempt was made to change the AutoCommit status of the DB session before inserting data.

Also wondering if this is relevant: https://luceeserver.atlassian.net/browse/LDEV-1005

Jamie Jackson 
19 September 2016 at 17:29

Mark Summers 
19 September 2016 at 08:25

Since has been closed, I will reiterate my question here: Will this code (from the Lucee 4 fix) ever run?

Fixed

Details

Assignee

Reporter

Priority

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

Affects versions

Created 17 August 2016 at 14:53
Updated 1 August 2017 at 22:41
Resolved 18 July 2017 at 19:35