Property To Enable SQL Commands

[JIMVANDRAGT]

I guess I'm not being clear.

Isn't there a db.properties entry we can add to see the generated SQL
statements that the method server is generating?

Jim Van Dragt
Product Development Systems Analyst/Developer
Information Technology
hermanmiller.com
616 654 5285 OFFICE
616 836 8394 MOBILE
HermanMiller




From: "Lockwood,Mike,IRVINE,R&D" <mike.lockwood@alconlabs.com>

[MikeLockwood]

Not aware of any.
But - One can easily see all using various database tools directly, including for example the SQL statements that consume the top few percent of resources.
The "Windchill Explorer" tool has some facilities for getting to the SQL from the object level.

From: Jim VanDragt [

[LakshmanEaswara]

Jim,



You can do that through
WT_HOME/codebase/WEB-INF/log4jMethodServer.properties



# Setup SQL logging to a separate file

log4j.logger.wt.pom.sql=ALL, persistenceLogFile

log4j.additivity.wt.pom.sql=false



No need to restart MS. Alternatively you can use wt.util.jmx.SetLogLevel
as well. I think this will direct log information to MS.log.



Thanks,

Lakshman Easwaran
Stryker
325 Corporate Drive
Mahwah, NJ 07430

[rjessen]

I think this is the one you're looking for; it's in db/db.properties

wt.pom.log.SQLStatements=true



From: Lockwood,Mike,IRVINE,R&D [

[JIMVANDRAGT]

This worked for me...Thanks for all the responses.

Jim Van Dragt
Product Development Systems Analyst/Developer
Information Technology
hermanmiller.com
616 654 5285 OFFICE
616 836 8394 MOBILE
HermanMiller




From: "Easwaran, Lakshman" <lakshman.easwaran@stryker.com>
To: "Jim VanDragt" <->,
"Lockwood,Mike,IRVINE,R&D" <mike.lockwood@alconlabs.com>