Transactions with mixture of ORM and vanilla SQL do not complete

Description

Since was resolved, running a queryExecute() after any ORM code inside a transaction causes the request to hang and never complete.

Example:

Previously, with LDEV-1564, this code would throw a "Not supported". Now it simply hangs the page. Step forward... I guess?

See attached stacktrace.

Environment

None

Attachments

3

Activity

Zac Spitzer 8 June 2023 at 18:09

test is passing?

Zac Spitzer 8 June 2023 at 18:09

Michael Born @ Ortus 21 September 2022 at 16:05

Actually, after more digging and testing on the latest Lucee 5.3.10 snapshot and Hibernate extension 5.4.29 snapshot… I think I’m seeing , not a regression of this table locking issue. I will comment on that ticket instead.

Pothys - MitrahSoft 21 September 2022 at 07:08

I've checked this issue with the lucee version 5.3.10.73-SNAPSHOT and Hibernate extension version 5.4.29.15-BETA and didn't occur the table locking issue.

Note: Once the request was hanging after that trying to execute the other SQL for the same table will be hanging until restarting the SQL server (or) Tomcat. So please make sure previously there is no hanging on the table before trying the other versions

Fixed

Details

Assignee

Reporter

Priority

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

Created 9 August 2021 at 13:30
Updated 1 July 2023 at 15:37
Resolved 1 February 2022 at 12:59