persistence@glassfish.java.net

Re: How to display Toplink's generated query?

From: gcsaba2 <gcsaba2_at_freemail.hu>
Date: Mon, 10 Mar 2008 14:16:52 -0700 (PDT)

Gordon Yorke-2 wrote:
>
> log.xml is the log location for TopLink in OC4J. If you have some
> queries there then all of TopLink logging is being written there and if
> some SQL is being logged then all of TopLink's SQL will be logged. What
> queries are you missing? Is it possible there are less queries because
> of the caching?
> --Gordon

Ah, so I DID find the log! :)
Well since I've set everything to maximum debugging, I get so much
information that I can barely find the queries. I'll try and limit it
somehow, I guess toplink.logging.level.sql should do the trick.

Yes, it's probably the caching that is hiding the queries. After initially
opening the webpage a few hundred queries are executed and the log file
becomes 3 MBs heavier, and after that it just stops getting updated until I
restart OC4J.

Thanks for the help!
-- 
View this message in context: http://www.nabble.com/How-to-display-Toplink%27s-generated-query--tp15892878p15957135.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.