I have a simple cfc file (test.cfc) like this:
property name="thename" type="string"
after that in my cfm file I do call like this:
myTest = new test();
wequery = new Query();
sql = "INSERT INTO TData
this will return error:
"this feature is not supported<br>The error occurred on line 110 in file /org/lucee/cfml/Base.cfc."
If I remove the transaction, then this is working fine.
Or If the code like this:
this is work fine too.
FYI, if I set this.ormEnabled = false, then no error. So it seems lucee still have bug ith ORM things ?
Strange problem when using Transaction. Currently I use lucee 18.104.22.168 with MSSQL as database. My application has setting this.ormEnabled = true
This is a blocker for us as well, would love to see it resolved after a few years now of running into this.
(and everyone else) ~ We've found that running a simple "select 1" achieves the same result (able to work around this bug).
Update: It seems that while the above query does stop Lucee from throwing an exception due to mixed ORM and SQL queries in the same transaction block (by running SQL first), the ORM changes don't get committed at all. We've had to start jumping through a few extra hoops to split SQL and ORM actions into separate transactions entirely in order to accomplish our needed changes.
In my mind, this has just become a much more severe bug.
We had to add ORMFlush() to the end of many transactions involving HQL and SQL. It was frustrating, since the whole point of using transactions (with flushAtRequestEnd = false) is to handle the Hibernate session for you.
Our ‘solution’ to this ticket was to move away from CFORM in favor of Quick and QB. It’s a multi-year process but ultimately Lucee has ceded the field on Hibernate support to Adobe. One could make the case that this is for good reason, but it’s become one of those things that “everybody knows” that if your app is ORM-heavy, switching to Lucee will be far more difficult than if you weren’t using Hibernate.
It sure would be nice if someone from LAS would even acknowledge this bug.