ORM AutoCommit value

Description

When running code below with ormEnabled set to true in Aplication.cfc

<cfscript>

dump(ORMGetSession().connection().getAutoCommit());

transaction {
dump(ORMGetSession().connection().getAutoCommit());
}

</cfscript>

we are getting true and true as output

Having autocommit set to true affects how code inside transaction block works

moreover when running code below with the same ORM settings

<cfscript>

dump(ORMGetSession().connection().getAutoCommit());

transaction {
dump(ORMGetSession().connection().getAutoCommit());
dump(ORMGetSession().connection().getAutoCommit());
}

</cfscript>

we are getting true and true and false as output

Our expectation is it should be false and false and false as in Railo 4.2.2.004

Activity

Show:
Pothys - MitrahSoft
December 6, 2016, 12:20 PM

I've analyzed this ticket a lot and found the issue. I couldn't able to use _InternalRequest() on lucee 4.5,so I've added detail description of issue given below

Inside the transaction tag AutoCommit value is false on railo-4.2.1.008 and latest version of lucee.It is not working fine on Lucee 4.5.3.xx versions.

Lucee 4.5.3.004

4.5.3.006

4.5.3.018

4.5.3.020

true,true,true

true,true,true

true,true,false

true,true,false

In RAILO 4.2.1.008 and latest version of lucee output as* true,false,false*

Michael Offner
December 19, 2016, 7:07 PM

is this an issue with Lucee 5?

Pothys - MitrahSoft
December 20, 2016, 5:31 AM

No, I couldn't able to reproduce the issue with Lucee5. As per the description, autocommit value should be false outside of transaction. But both lucee5 & ACF11 returns true in that case. So it is working fine in Lucee5.

Pothys - MitrahSoft
July 17, 2020, 1:18 PM
Edited

For this ticket, lucee returns true for outside transaction as I said above comment. For inside transaction, it returns as false.
ACF returns true for both the transactions. will decide about this?

Assignee

Michael Offner

Reporter

S

Labels

Affects versions

Priority

Minor
Configure