I've set every logging properties file that I could find to DEBUG or FINEST
mode, I opened Oracle's Enterprise manager and set every debugging property
I could find to true... and I'm not sure if any of these had an effect or
not, but I've found something which seems to contains SOME of the generated
queries. The file is oc4j/j2ee/home/log/oc4j/log.xml
It's an xml file which contains lots of garbage, and there I could find a
few generated queries. So now I can see what was wrong specifically with the
query I was trying to fix. However, I see that not all of the queries are
displayed there, so this is probably not what I was looking for... but
anyway at least now I have some clues.
When Toplink starts, I get a message saying:
2008-03-10 08:22:17.654 NOTIFICATION TopLink, version: Oracle TopLink
Essentials - 2.0 (Build b41-beta2 (03/30/2007))
2008-03-10 08:22:17.669 NOTIFICATION Server: unknown
Somehow I get the feeling from this that Toplink is set to some debugging
level where it only writes out notifications, and nothing above it. The
queries in log.xml may be coming from OC4J itself, because as far as I could
find out, TopLink doesn't use log.xml for its logging.
I hope this may give some clues what is wrong...?
--
View this message in context: http://www.nabble.com/How-to-display-Toplink%27s-generated-query--tp15892878p15950583.html
Sent from the java.net - glassfish persistence mailing list archive at Nabble.com.