Dondon22 Respected Contributor.
Respected Contributor.
388 views

OO 10.70 - db.show_sql=false in database.properties, is it ok to make it true?

Hi!

I want to see the sql statements being executed by OO but I dont know if this is the correct setting or not and is there a drawback if i make it to true?

TIA.

Regards,

Don

In IT there is no Magic, just Logic ^_^
0 Likes
1 Reply
Outstanding Contributor.. JarodMB Outstanding Contributor..
Outstanding Contributor..

Re: OO 10.70 - db.show_sql=false in database.properties, is it ok to make it true?

You will increase content written to the logs - if its a busy host with limited resources you could see a performance hit

if you want to enable debug 
log4j.properties -> log.level=DEBUG

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.