Bug 7170

Summary: JDBCStore don't work with Orcale 8.x
Product: Tomcat 4 Reporter: Peter Rossbach <pr>
Component: CatalinaAssignee: Tomcat Developers Mailing List <dev>
Status: RESOLVED FIXED    
Severity: blocker CC: axelcloe, jesandberg, seweryn.sobieszek
Priority: P3    
Version: 4.0.2 Final   
Target Milestone: ---   
Hardware: Other   
OS: other   
Attachments: Patch of org.apache.catalina.session.JDBCStore. Fix the invalid GROUP-BY expression & some NullPointerExceptions

Description Peter Rossbach 2002-03-16 08:13:37 UTC
Change Line 391 at method    public String[] keys() throws IOException {
 
           "SELECT COUNT(s."+sessionIdCol+"), s."+sessionIdCol+
to
           "SELECT COUNT(s."+sessionIdCol+"), c."+sessionIdCol+

The Logger send following error before I change it:

2002-03-15 21:13:21 JDBCStore[/echo]: SQL Error java.sql.SQLException: ORA-
00979: kein GROUP BY-Ausdruck

Testet with 4.0.2 final and nightly build
Comment 1 scottykwok 2002-03-17 04:42:06 UTC
Created attachment 1359 [details]
Patch of org.apache.catalina.session.JDBCStore. Fix the invalid GROUP-BY expression & some NullPointerExceptions
Comment 2 Remy Maucherat 2002-04-17 17:03:25 UTC
*** Bug 8196 has been marked as a duplicate of this bug. ***
Comment 3 Remy Maucherat 2002-04-17 17:10:55 UTC
I have applied the patch which was originally submitted. Thanks (and sorry for
the delay).
Comment 4 Remy Maucherat 2002-04-23 11:07:27 UTC
*** Bug 4961 has been marked as a duplicate of this bug. ***
Comment 5 Remy Maucherat 2002-04-29 06:56:06 UTC
*** Bug 8564 has been marked as a duplicate of this bug. ***