Oracle transaction isolation bug

Description

Discussion:
https://dev.lucee.org/t/a-crazy-db-problem/7113/3

Test case:
Using Oracle 11 driver on Lucee 5.3.6.61
Implement a transaction using <cftransaction>
When running the code the following error will occur
"READ_COMMITTED and SERIALIZABLE are the only valid transaction levels"

Downgrade to Lucee 5.3.5.92 and run the same cftransaction, error does not occur.

Environment

None

Activity

Show:
Dean Maunder
November 5, 2020, 1:46 AM

I downloaded 5.3.8.95-SNAPSHOT for this and tested and the error is still occuring. Stack trace attached

 

Michael Offner
November 5, 2020, 9:40 AM

Michael Offner
November 5, 2020, 9:40 AM

can you please give version .101 another try

Dean Maunder
November 5, 2020, 11:51 PM

Looks much better - Will give it some serious testing over the next week

Dean Maunder
3 days ago

we have been testing this for a few weeks now and have not seen any further issues 👍

Assignee

Pothys - MitrahSoft

Reporter

Dean Maunder

Priority

New

Labels

Fix versions

Affects versions

Configure