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
gcsaba2 wrote:
> 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...?
>
>
>