Bug 7170 - JDBCStore don't work with Orcale 8.x
Summary: JDBCStore don't work with Orcale 8.x
Status: RESOLVED FIXED
Alias: None
Product: Tomcat 4
Classification: Unclassified
Component: Catalina (show other bugs)
Version: 4.0.2 Final
Hardware: Other other
: P3 blocker (vote)
Target Milestone: ---
Assignee: Tomcat Developers Mailing List
URL:
Keywords:
: 4961 8196 8564 (view as bug list)
Depends on:
Blocks:
 
Reported: 2002-03-16 08:13 UTC by Peter Rossbach
Modified: 2004-11-16 19:05 UTC (History)
3 users (show)


Attachments
Patch of org.apache.catalina.session.JDBCStore. Fix the invalid GROUP-BY expression & some NullPointerExceptions (3.27 KB, patch)
2002-03-17 04:42 UTC, scottykwok 		Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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. ***