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: [email protected] To
> unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: [email protected] To
> unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
