Thanks for your response; I will look into the SQL code Dwight
-----Original Message----- From: gb1071nx [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 27, 2007 9:47 AM To: Tomcat Users List Subject: RE: TOMCAT 5.0.28 stability This is certainly not a tomcat stability problem, it's the application that has been coded poorly > syntax to use near 's Time Management workshop You've got some SQL code somewhere that looks like this: String sql = "INSERT INTO table (foo) VALUES('" + fooVar + "')"; And you're inserting data (fooVar variable contains) "Manager's Time Management workshop" Which results in SQL that looks like: INSERT INTO table (foo) VALUES('Manager's Time Management workshop') Notice how the single quote results in mal-formed SQL? > -----Original Message----- > From: Dwight Farris [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 27, 2007 11:34 AM > To: 'Tomcat Users List' > Subject: TOMCAT 5.0.28 stability > > Hello Bob, > I made the change in CATALINA_OPTS in catalina.sh; and I > searched the Catalina.out file for exceptions with the > following returning: > > java.sql.SQLException: You have an error in your SQL > syntax; check > the manual that corresponds to your MySQL server version > for the right > syntax to use near 's Time Management workshop > > java.sql.SQLException: Illegal operation on empty result set... > > If I am not mistaken, there appears to be an issue with > resource centered on data manipulation. I am continuously > writing data from a data warehouse to a "local" MySQL data > repository. I envision receiving a number of these types of > exceptions; however I am beginning to believe TOMCAT 5.0 has > an "issue" supporting the processes from MySQL. > > The premise of this assumption stems from the fact that I > have the same scenario running on a TOMCAT 5.5 development > platform and it will only stop running when the app fails on 5.0. > > Hope this makes some sense. > > Dwight > > ______________________________________________________________ > ______________ > If your webapp(s) really need a gig of memory, I sugggest > changing CATALINA_OPTS > > CATALINA_OPTS="$CATALINA_OPTS -Xms1024m -Xmx1024m" > > Looks like you are using unix/linux. Did you 'grep' > for Exception and Error in catalina.out? > > The Cohorts getName() messages don't look familiar to me. Is > there a Cohorts class in one or more of your webapp's? > > -Bob > > > > > ______________________________________________________________ > ______________ > ________ > Never miss an email again! > Yahoo! Toolbar alerts you the instant new Mail arrives. > http://tools.search.yahoo.com/toolbar/features/mail/ > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org To > unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org To > unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
