FINEST is the most verbose log setting in TOPLINK. If you are not getting SQL after setting this property they may be a problem with the way you have set the property (see the email from Peter Krogh for details) or the log may be printing to an unexpected spot.
In Glassfish the log is written into a log file under the domain by default.
If this does not help can you provide the details on how you are configuring logging and which application server (if any) you are running on.
--Gordon
-----Original Message-----
From: gcsaba2 [mailto:gcsaba2_at_freemail.hu]
Sent: Friday, March 07, 2008 9:49 AM
To: persistence_at_glassfish.dev.java.net
Subject: How to display Toplink's generated query?
Is there a way I can see what query TopLink generates? For example, if I
write "from Post", then it probably generates something like "select p.id,
p.name, p.date from Post p"
You can see this kind of message when there's an error in the SQL query, for
example when a foreign key is violated, but I'd like to display it at all
time. In Hibernate this can be done by simply setting the debug level to
DEBUG.
In TopLink I have the debug level set to FINEST, but it doesn't print the
queries.
--
View this message in context: http://www.nabble.com/How-to-display-Toplink%27s-generated-query--tp15892878p15892878.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.