Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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:

Zac Spitzer 21 June 2021 at 14:24

duplicate

Julian Halliwell 13 November 2019 at 11:48

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.

Marc Ackermann 15 June 2017 at 08:07
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?

Michael Offner 15 June 2017 at 06:52

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

Fixed

Details

Assignee

Reporter

Labels

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

Affects versions

Priority

Created 11 June 2017 at 12:54
Updated 21 June 2021 at 14:24
Resolved 21 June 2021 at 14:24