Skip to main content
J
jv83421-Visitor
1-Visitor
June 28, 2011
Question

Property To Enable SQL Commands

  • June 28, 2011
  • 4 replies
  • 1182 views
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>

4 replies

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
June 28, 2011
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 [
L
LakshmanEaswara1-Visitor
1-Visitor
June 28, 2011
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
R
rjessen3-Newcomer
3-Newcomer
June 28, 2011
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 [
J
jv83421-VisitorAuthor
1-Visitor
June 28, 2011
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>
Terms & ConditionsAccessibility statement