ORM Log SQL not working

Description

In the Lucee Server Administrator on the ORM Page I set the "Log SQL" checkbox. But it has not effect. I see all the debuging output but no ORM SQL in it. If I write some cfquery statement in the template I do see the SQL in the debuging.

Activity

Show:
Michael Offner
June 15, 2017, 6:52 AM

are you expecting that the orm query are showing up in the Lucee debug output?

Marc Ackermann
June 15, 2017, 8:07 AM
Edited

Yes I would expect the same ouput as using cfquery:
--------------------------------------------------------------
Datasource Information
1 Query Executed (Total Records: 1; Total Time: 19.353 ms; Total Open Connections: 2)
General
Name Open Connections Max Connections
ormtest 2 100

SQL Queries
Name Records Time (ms) Datasource Source Cache Type
1 19.353 ormtest D:\inetpub\website01\httpdoc\index.cfm none
SQL:

SELECT [id]
,[inhalt]
FROM [dbo].[marc]

Query usage within the request
Unused: id , inhalt
100 %
------------------------------

But when using ORM there is no information at all in the debug output.
So I don't understand what the chechbox "Log SQL" on the Server Admin / ORM Page is for?

Julian Halliwell
November 13, 2019, 11:48 AM

The logSql ORM setting causes SQL queries to be logged to the lucee-stdout.DATE.log file, which in a Tomcat installation is located in the lucee/tomcat/logs/ folder.

It doesn't have any effect on debug output.

Assignee

Michael Offner

Reporter

Marc Ackermann

Labels

Affects versions

Priority

Major
Configure