Re: TRACE messages
Well, I know you are all sitting on the edge of your chairs waiting for the solution to this... 2 make a long story short: Failure to thoroughly search the documentation led me to install a DEBUG version of connectorj. The tarball has 2 connectorj jar files, one which is a debug version and in my haste, i used the wrong one. No wonder no one else ever saw this problem! I must be the dumbest guy in the world since I am the only one who ever had this happen. Thanks, and I hope I didn't waste anybody's time Mike Mike Sabroff wrote: Just in case someone else comes across this error, I found this code in the mysql connectorj Jdk14Logger.java: private void logInternal(int level, Object msg, Throwable exception) { StringBuffer msgBuf = new StringBuffer(); msgBuf.append(new Date().toString()); msgBuf.append( ); switch (level) {case FATAL: msgBuf.append(FATAL: ); break; case ERROR: msgBuf.append(ERROR: ); break; case WARN: msgBuf.append(WARN: ); break; case INFO: msgBuf.append(INFO: ); break; case DEBUG: msgBuf.append(DEBUG: ); break; case TRACE: msgBuf.append(TRACE: ); break; } So..whoever said it was something in my webapps was right. Mike Sabroff wrote: I am not sure if this is a Tomcat issue or a MySql issue. I get these trace messages in catalina.out: Wed Mar 08 07:48:48 CST 2006 TRACE: about 800 to 1000 lines of them, each time I connect to the database. I have googled and searched but can find nothing on the cause or the solution except maybe to use log4j. I have several versions of Tomcat 4.x / 5.x and it happens in all cases I don't really think it is a Tomcat issue, but was hoping someone else has experienced the problem and could lead me in the right direction. Any help would be appreciated. Thanks, Mike -- Mike Sabroff Web Services Developer [EMAIL PROTECTED] 920-568-8379 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: TRACE messages
Given the extreme lack of any info to base a diagnosis on, I'd say you have a library in your webapp generating this to standard out. My MySQL install does not do this. --David Mike Sabroff wrote: I am not sure if this is a Tomcat issue or a MySql issue. I get these trace messages in catalina.out: Wed Mar 08 07:48:48 CST 2006 TRACE: about 800 to 1000 lines of them, each time I connect to the database. I have googled and searched but can find nothing on the cause or the solution except maybe to use log4j. I have several versions of Tomcat 4.x / 5.x and it happens in all cases I don't really think it is a Tomcat issue, but was hoping someone else has experienced the problem and could lead me in the right direction. Any help would be appreciated. Thanks, Mike - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: TRACE messages
Mike Sabroff ha scritto: I am not sure if this is a Tomcat issue or a MySql issue. I get these trace messages in catalina.out: Wed Mar 08 07:48:48 CST 2006 TRACE: about 800 to 1000 lines of them, each time I connect to the database. I have googled and searched but can find nothing on the cause or the solution except maybe to use log4j. If you are using log4j, maybe you put a debug level to your root logger. Put the correct logging level to the root logger (I suggest at least INFO) and your desired level to your own logger. Ciao Antonio - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: TRACE messages
Thanks Dave, I will scour my webapps to see if this is true, since I do have some common jars to all my webapps Mike David Smith wrote: Given the extreme lack of any info to base a diagnosis on, I'd say you have a library in your webapp generating this to standard out. My MySQL install does not do this. --David Mike Sabroff wrote: I am not sure if this is a Tomcat issue or a MySql issue. I get these trace messages in catalina.out: Wed Mar 08 07:48:48 CST 2006 TRACE: about 800 to 1000 lines of them, each time I connect to the database. I have googled and searched but can find nothing on the cause or the solution except maybe to use log4j. I have several versions of Tomcat 4.x / 5.x and it happens in all cases I don't really think it is a Tomcat issue, but was hoping someone else has experienced the problem and could lead me in the right direction. Any help would be appreciated. Thanks, Mike - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Mike Sabroff Web Services Developer [EMAIL PROTECTED] 920-568-8379 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: TRACE messages
actually not using log4j, just thought it might be a way to redefine what I log. thx Antonio Petrelli wrote: Mike Sabroff ha scritto: I am not sure if this is a Tomcat issue or a MySql issue. I get these trace messages in catalina.out: Wed Mar 08 07:48:48 CST 2006 TRACE: about 800 to 1000 lines of them, each time I connect to the database. I have googled and searched but can find nothing on the cause or the solution except maybe to use log4j. If you are using log4j, maybe you put a debug level to your root logger. Put the correct logging level to the root logger (I suggest at least INFO) and your desired level to your own logger. Ciao Antonio - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Mike Sabroff Web Services Developer [EMAIL PROTECTED] 920-568-8379 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: TRACE messages
Just in case someone else comes across this error, I found this code in the mysql connectorj Jdk14Logger.java: private void logInternal(int level, Object msg, Throwable exception) { StringBuffer msgBuf = new StringBuffer(); msgBuf.append(new Date().toString()); msgBuf.append( ); switch (level) {case FATAL: msgBuf.append(FATAL: ); break; case ERROR: msgBuf.append(ERROR: ); break; case WARN: msgBuf.append(WARN: ); break; case INFO: msgBuf.append(INFO: ); break; case DEBUG: msgBuf.append(DEBUG: ); break; case TRACE: msgBuf.append(TRACE: ); break; } So..whoever said it was something in my webapps was right. Mike Sabroff wrote: I am not sure if this is a Tomcat issue or a MySql issue. I get these trace messages in catalina.out: Wed Mar 08 07:48:48 CST 2006 TRACE: about 800 to 1000 lines of them, each time I connect to the database. I have googled and searched but can find nothing on the cause or the solution except maybe to use log4j. I have several versions of Tomcat 4.x / 5.x and it happens in all cases I don't really think it is a Tomcat issue, but was hoping someone else has experienced the problem and could lead me in the right direction. Any help would be appreciated. Thanks, Mike -- Mike Sabroff Web Services Developer [EMAIL PROTECTED] 920-568-8379 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]