re: Why does JDBC application logging SQL instructions in Apache Tomcat lists 545 repeatedly

2013-08-06 Thread appy74 
This has now been resolved. Thanks anyway.
-- 



-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

RE: Why does JDBC application logging SQL instructions in Apache Tomcat lists 545 repeatedly

2013-08-06 Thread Martin O'Shea 
This is now resolved. Thanks anyway.

-Original Message-
From: app...@dsl.pipex.com [mailto:app...@dsl.pipex.com] 
Sent: 06 Aug 2013 00 30
To: users@tomcat.apache.org
Subject: Why does JDBC application logging SQL instructions in Apache Tomcat
lists 545 repeatedly

I'm not sure of this is an Apache Tomcat issue or not but here goes: I am
currently running a number of programs in batch which dynamically create and
populate a number of tables in MySQL Server Version 5.5. 

When I do this, I am logging the SQL to an Apache Tomcat log file. Sometimes
the SQL listings will list a particular series of queries reading the
title elements of RSS feeds one by one such as:
  
SELECT TITLE  FROM _rss_172_917617_01012011_1293889632011 WHERE
CreatedDateTime BETWEEN '2011-07-01 00:00:00' 
AND '2011-07-31 23:59:00';
SELECT TITLE  FROM _rss_173_353205_01012011_1293889643042 WHERE
CreatedDateTime BETWEEN '2011-07-01 00:00:00' 
AND '2011-07-31 23:59:00';

Then the name of the system will be printed as follows in the log file:

[myApp]

And then there will be a series of lines reading:

545

Before the next series of queries run. And when the next series of queries
does run, the text of each query is listed, and then another line lists the
system name.

SELECT TITLE  FROM _rss_121_298920_24122010_1293174184748 WHERE
CreatedDateTime BETWEEN '2011-07-01 00:00:00' 
AND '2011-07-01 23:59:00';
[myApp]

MyApp is written in Java and running under Tomcat 6.0.26. I should add that
sometimes the number of queries producing the data for one table, which may
number in the hundreds, appear to be fine. Other times the 545 message is
listed: this appears to be sporadic with no apparent pattern.

Though the queries appear to be running, can anyone tell me what 545 might
mean? It seems to happen on two separate servers running the same programs
but over different data.

-- 


-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Re: Why does JDBC application logging SQL instructions in Apache Tomcat lists 545 repeatedly

2013-08-06 Thread chris derham 
On Tue, Aug 6, 2013 at 7:52 AM, Martin O'Shea app...@dsl.pipex.com wrote:
 This is now resolved. Thanks anyway.

For the benefit of anybody else that hits this issue, care to explain
how it was resolved?

Thanks

Chris

-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

RE: Why does JDBC application logging SQL instructions in Apache Tomcat lists 545 repeatedly

2013-08-06 Thread Martin O'Shea 
Apologies, I should have explained.

This issue was caused by as pair of rogue System.out.println statements
which had been used for debugging. They were erroneously retained when the
code went live.

-Original Message-
From: cjder...@gmail.com [mailto:cjder...@gmail.com] On Behalf Of chris
derham
Sent: 06 Aug 2013 12 20
To: Tomcat Users List
Subject: Re: Why does JDBC application logging SQL instructions in Apache
Tomcat lists 545 repeatedly

On Tue, Aug 6, 2013 at 7:52 AM, Martin O'Shea app...@dsl.pipex.com wrote:
 This is now resolved. Thanks anyway.

For the benefit of anybody else that hits this issue, care to explain how it
was resolved?

Thanks

Chris

-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org


-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Why does JDBC application logging SQL instructions in Apache Tomcat lists 545 repeatedly

2013-08-05 Thread appy74 
I'm not sure of this is an Apache Tomcat issue or not but here goes: I am 
currently running a number of programs in 
batch which dynamically create and populate a number of tables in MySQL Server 
Version 5.5. 

When I do this, I am logging the SQL to an Apache Tomcat log file. Sometimes 
the SQL listings 
will list a particular series of queries reading the title elements of RSS 
feeds one by one such as:
  
SELECT TITLE  FROM _rss_172_917617_01012011_1293889632011 WHERE 
CreatedDateTime BETWEEN '2011-07-01 00:00:00' 
AND '2011-07-31 23:59:00';
SELECT TITLE  FROM _rss_173_353205_01012011_1293889643042 WHERE 
CreatedDateTime BETWEEN '2011-07-01 00:00:00' 
AND '2011-07-31 23:59:00';

Then the name of the system will be printed as follows in the log file:

[myApp]

And then there will be a series of lines reading:

545

Before the next series of queries run. And when the next series of queries does 
run, the text of each query is 
listed, and then another line lists the system name.

SELECT TITLE  FROM _rss_121_298920_24122010_1293174184748 WHERE 
CreatedDateTime BETWEEN '2011-07-01 00:00:00' 
AND '2011-07-01 23:59:00';
[myApp]

MyApp is written in Java and running under Tomcat 6.0.26. I should add that 
sometimes the number of queries 
producing the data for one table, which may number in the hundreds, appear to 
be fine. Other times the 545 message 
is listed: this appears to be sporadic with no apparent pattern.

Though the queries appear to be running, can anyone tell me what 545 might 
mean? It seems to happen on two separate 
servers running the same programs but over different data.

-- 


-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org