Hi Roland,
I had looked at the *_debug file, the *_response and *_rss.
I was not looking at the correct file name and unfortunately there were no *_db_debug file for this particular file name. I have now found the associated *_db_debug for the file of interest.
Thanks for your help!
Jerome.
Date: Mon, 28 Jan 2008 13:36:17 -0600 From: Roland.Schweitzer@xxxxxxxx Subject: Re: [las_users] SQL query in logs To: jejeking@xxxxxxxxxxx CC: oar.pmel.las_users@xxxxxxxx
Jerome,
If you are using our database backend service, then the query that is
run (whether it fails or succeeds) should be available in a
*_db_debug.txt file in the output directory for your LAS (typically
$TOMCAT_HOME/webapps/las/output).
Roland
Jerome King wrote:
Hi Roland and other LAS experts,
When a SQL query fails in LAS Armstrong, it appears in the output
window or in the catalina.out.
When a SQL query succeed, I am not sure if it appears anywhere in any
logs?
I have 2 LAS Armstrong where I believe the same SQL query works in one
and fails in the other, but I can't find the SQL query for the
successful LAS. And I want to make sure they are the same before I
check other avenues.
Can you confirm that it does or does not record it and if it does could
you point me to the log where it records the SQL statement for a
successful query?
Thanks,
Jerome.
Climb to the top of the charts! Play the word scramble challenge
with star power. Play now!
Connect and share in new ways with Windows Live. Get it now!
|