Error when executing a query within a transaction

Description

I am doing a query execute within a transaction and I am getting the following error:

General application error: this feature is not supported, Detail: , StackTrace: lucee.runtime.exp.DatabaseException: this feature is not supported at lucee.runtime.orm.ORMConnection.notSupported(ORMConnection.java:304)

The PreparedStatement function is not supported as we can see in this file.

This is blocking me at the moment and I hope this can be addressed.

Environment

None

Activity

Show:
Luis Majano
February 20, 2020, 3:42 AM

I am able to reproduce this all the time in another project I am working on. I will try to give you the details below.

 

I have an overarching transaction surrounding lots of code points. Some have inner transactions using the ORM and some just plain queryExecutes(). The graph can look like this:

 

 

As you can see, it is an overarching transaction block over the include in the onRequest() function. Inside of the target page you can have:

  • queryExecute()

  • nested transaction{ orm code; orm saves; }

  • nested transaction { orm code; orm saves; }

  • queryExecute()

 

Those queryExecutes() will fail with the exeception above.

 

Luis Majano
February 26, 2020, 5:04 PM

Any update on this

Luis Majano
March 2, 2020, 10:39 PM

Any update on this issue

Samuel W. Knowlton
March 9, 2020, 7:23 PM

This seems quite similar to

Luis Majano
March 10, 2020, 2:08 AM

Any update in this issue?

Assignee

Unassigned

Reporter

Javier Quintero

Priority

Blocker

Labels

Fix versions

None

Affects versions

Configure