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]>

Reply via email to