DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8564>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8564 keysSql not formatted for DB2 database Summary: keysSql not formatted for DB2 database Product: Tomcat 4 Version: 4.0.3 Final Platform: All OS/Version: Other Status: NEW Severity: Blocker Priority: Other Component: Catalina AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] In the class org.apache.catalina.sessions.JDBCStore which I am using for storing persistent sessions to a DB2 database, the SQLSTATE 42803 error came up as a COM.ibm.db2.jdbc.DB2Exception was thrown. I traced the problem back to the JDBCStore source, line 390, where the following statement is issued: String keysSql = "SELECT COUNT(s."+sessionIdCol+"), s."+sessionIdCol+" FROM "+sessionTable+" s, " +sessionTable+" c" +" GROUP BY c."+sessionIdCol; This statement was throwing the error in DB2, so I replaced it with: String keysSql = "SELECT COUNT(s."+sessionIdCol+"), s."+sessionIdCol+" FROM "+sessionTable+" s" +" GROUP BY s."+sessionIdCol; I asked a DB2 expert at my company and he said that because of the higher level of error checking in DB2 as compared to other databases, the format of this statement was incorrect. With this fix, I no longer get the Exception. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
