You are viewing a plain text version of this content. The canonical link for it is here.
Posted to general@jakarta.apache.org by Giovanni Zorzan <gi...@lumetel.it> on 2002/01/29 17:17:00 UTC
possibly bug with tomcat 4 vs oracle 8.1.7 ??
we try to use JDBCStore against a Oracle 8i database.
the connection works (and tomcat insert some rows into table session), but
in the log we have seen this:
2002-01-29 16:47:42 PersistentManager[/lumetel]: Stopping
2002-01-29 16:47:42 PersistentManager[/lumetel]: Saving 1 persisted sessions
2002-01-29 16:47:43 JDBCStore[/lumetel]: Removing Session
7854023989A8A7D1F265633805523385 at database tomcat_sessions
2002-01-29 16:47:43 PersistentManager[/lumetel]: writeObject() storing
session 7854023989A8A7D1F265633805523385
2002-01-29 16:47:43 PersistentManager[/lumetel]: storing attribute
'SesCategory' with value 'F'
2002-01-29 16:47:43 PersistentManager[/lumetel]: storing attribute
'poolname' with value 'forum'
2002-01-29 16:47:43 PersistentManager[/lumetel]: storing attribute
'sezione' with value 'aziende'
2002-01-29 16:47:43 JDBCStore[/lumetel]: Saving Session
7854023989A8A7D1F265633805523385 to database tomcat_sessions
2002-01-29 16:47:54 WebappLoader[/lumetel]: Deploying class repositories to
work directory /var/tomcat4/work/als.lumetel.it/lumetel
2002-01-29 16:47:54 PersistentManager[/lumetel]: Starting
2002-01-29 16:47:54 PersistentManager[/lumetel]: Force random number
initialization starting
2002-01-29 16:47:54 PersistentManager[/lumetel]: Seeding random number
generator class java.security.SecureRandom
2002-01-29 16:47:54 PersistentManager[/lumetel]: Seeding of random number
generator has been completed
2002-01-29 16:47:54 PersistentManager[/lumetel]: Getting message digest
component for algorithm MD5
2002-01-29 16:47:54 PersistentManager[/lumetel]: Completed getting message
digest component
2002-01-29 16:47:54 PersistentManager[/lumetel]: Force random number
initialization completed
2002-01-29 16:47:54 JDBCStore[/lumetel]: The database connection is null or
was found to be closed. Trying to re-open it.
2002-01-29 16:47:56 ContextConfig[/lumetel]: Configured an authenticator
for method FORM
2002-01-29 16:47:56 StandardWrapper[/lumetel:default]: Loading container
servlet default
2002-01-29 16:47:56 default: init
2002-01-29 16:47:56 StandardWrapper[/lumetel:invoker]: Loading container
servlet invoker
2002-01-29 16:47:56 invoker: init
2002-01-29 16:47:56 jsp: init
2002-01-29 16:48:32 JDBCStore[/lumetel]: Removing Session
67C3B5C895E57191C54860B35775C3B9 at database tomcat_sessions
2002-01-29 16:48:32 PersistentManager[/lumetel]: readObject() loading
session 7854023989A8A7D1F265633805523385
2002-01-29 16:48:32 PersistentManager[/lumetel]: loading attribute
'SesCategory' with value 'F'
2002-01-29 16:48:32 PersistentManager[/lumetel]: loading attribute
'poolname' with value 'forum'
2002-01-29 16:48:32 PersistentManager[/lumetel]: loading attribute
'sezione' with value 'aziende'
2002-01-29 16:48:32 JDBCStore[/lumetel]: Loading Session
7854023989A8A7D1F265633805523385 from database tomcat_sessions
2002-01-29 16:48:32 PersistentManager[/lumetel]: Swapping session
7854023989A8A7D1F265633805523385 in from Store
2002-01-29 16:48:33 jsp: init
2002-01-29 16:48:33 jsp: init
2002-01-29 16:48:55 JDBCStore[/lumetel]: SQL Error java.sql.SQLException:
ORA-00979: not a GROUP BY expression
with toad (oracle tool) we have seen that the last line is caused by:
SELECT
COUNT(s.session_id),
s.session_id
FROM
tomcat_sessions s,
tomcat_sessions c GROUP BY c.session_id
the error is in group by expression; the "group by" element must be in the
select list. For us the correct sintax is:
SELECT
COUNT(s.session_id),
s.session_id
FROM
tomcat_sessions s,
tomcat_sessions c GROUP BY s.session_id
thank you for your time!
[]---------[ Giovanni Zorzan ]---------[]
[]---------[ Agenzia Lumetel Scrl ]---------[]
[]---------[ giovanni@lumetel.it ]---------[]
Re: possibly bug with tomcat 4 vs oracle 8.1.7 ??
Posted by "Craig R. McClanahan" <cr...@apache.org>.
On Tue, 29 Jan 2002, Giovanni Zorzan wrote:
> Date: Tue, 29 Jan 2002 17:17:00 +0100
> From: Giovanni Zorzan <gi...@lumetel.it>
> Reply-To: Jakarta General List <ge...@jakarta.apache.org>
> To: general@jakarta.apache.org
> Subject: possibly bug with tomcat 4 vs oracle 8.1.7 ??
>
> we try to use JDBCStore against a Oracle 8i database.
> the connection works (and tomcat insert some rows into table session), but
> in the log we have seen this:
>
This is a posting that should be directed to the TOMCAT-USER list, not
here -- subscription information, as well as documentation on what each
mailing list is for, can be found at:
http://jakarta.apache.org/site/mail.html
Craig McClanahan
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: possibly bug with tomcat 4 vs oracle 8.1.7 ??
Posted by Gerhard Froehlich <g-...@gmx.de>.
Hi,
wrong list, try the tomcat mail lists instead:
http://jakarta.apache.org/site/mail.html
http://jakarta.apache.org/tomcat/index.html
Gerhard
--------------------------------------------
Give me ambiguity or give me something else.
--------------------------------------------
>-----Original Message-----
>From: Giovanni Zorzan [mailto:giovanni@lumetel.it]
>Sent: Tuesday, January 29, 2002 5:17 PM
>To: general@jakarta.apache.org
>Subject: possibly bug with tomcat 4 vs oracle 8.1.7 ??
>
>
>we try to use JDBCStore against a Oracle 8i database.
>the connection works (and tomcat insert some rows into table session), but
>in the log we have seen this:
>
>2002-01-29 16:47:42 PersistentManager[/lumetel]: Stopping
>2002-01-29 16:47:42 PersistentManager[/lumetel]: Saving 1 persisted sessions
>2002-01-29 16:47:43 JDBCStore[/lumetel]: Removing Session
>7854023989A8A7D1F265633805523385 at database tomcat_sessions
>2002-01-29 16:47:43 PersistentManager[/lumetel]: writeObject() storing
>session 7854023989A8A7D1F265633805523385
>2002-01-29 16:47:43 PersistentManager[/lumetel]: storing attribute
>'SesCategory' with value 'F'
>2002-01-29 16:47:43 PersistentManager[/lumetel]: storing attribute
>'poolname' with value 'forum'
>2002-01-29 16:47:43 PersistentManager[/lumetel]: storing attribute
>'sezione' with value 'aziende'
>2002-01-29 16:47:43 JDBCStore[/lumetel]: Saving Session
>7854023989A8A7D1F265633805523385 to database tomcat_sessions
>2002-01-29 16:47:54 WebappLoader[/lumetel]: Deploying class repositories to
>work directory /var/tomcat4/work/als.lumetel.it/lumetel
>2002-01-29 16:47:54 PersistentManager[/lumetel]: Starting
>2002-01-29 16:47:54 PersistentManager[/lumetel]: Force random number
>initialization starting
>2002-01-29 16:47:54 PersistentManager[/lumetel]: Seeding random number
>generator class java.security.SecureRandom
>2002-01-29 16:47:54 PersistentManager[/lumetel]: Seeding of random number
>generator has been completed
>2002-01-29 16:47:54 PersistentManager[/lumetel]: Getting message digest
>component for algorithm MD5
>2002-01-29 16:47:54 PersistentManager[/lumetel]: Completed getting message
>digest component
>2002-01-29 16:47:54 PersistentManager[/lumetel]: Force random number
>initialization completed
>2002-01-29 16:47:54 JDBCStore[/lumetel]: The database connection is null or
>was found to be closed. Trying to re-open it.
>2002-01-29 16:47:56 ContextConfig[/lumetel]: Configured an authenticator
>for method FORM
>2002-01-29 16:47:56 StandardWrapper[/lumetel:default]: Loading container
>servlet default
>2002-01-29 16:47:56 default: init
>2002-01-29 16:47:56 StandardWrapper[/lumetel:invoker]: Loading container
>servlet invoker
>2002-01-29 16:47:56 invoker: init
>2002-01-29 16:47:56 jsp: init
>2002-01-29 16:48:32 JDBCStore[/lumetel]: Removing Session
>67C3B5C895E57191C54860B35775C3B9 at database tomcat_sessions
>2002-01-29 16:48:32 PersistentManager[/lumetel]: readObject() loading
>session 7854023989A8A7D1F265633805523385
>2002-01-29 16:48:32 PersistentManager[/lumetel]: loading attribute
>'SesCategory' with value 'F'
>2002-01-29 16:48:32 PersistentManager[/lumetel]: loading attribute
>'poolname' with value 'forum'
>2002-01-29 16:48:32 PersistentManager[/lumetel]: loading attribute
>'sezione' with value 'aziende'
>2002-01-29 16:48:32 JDBCStore[/lumetel]: Loading Session
>7854023989A8A7D1F265633805523385 from database tomcat_sessions
>2002-01-29 16:48:32 PersistentManager[/lumetel]: Swapping session
>7854023989A8A7D1F265633805523385 in from Store
>2002-01-29 16:48:33 jsp: init
>2002-01-29 16:48:33 jsp: init
>2002-01-29 16:48:55 JDBCStore[/lumetel]: SQL Error java.sql.SQLException:
>ORA-00979: not a GROUP BY expression
>
>with toad (oracle tool) we have seen that the last line is caused by:
>
>SELECT
> COUNT(s.session_id),
> s.session_id
>FROM
> tomcat_sessions s,
> tomcat_sessions c GROUP BY c.session_id
>
>the error is in group by expression; the "group by" element must be in the
>select list. For us the correct sintax is:
>
>SELECT
> COUNT(s.session_id),
> s.session_id
>FROM
> tomcat_sessions s,
> tomcat_sessions c GROUP BY s.session_id
>
>thank you for your time!
>
>
>
> []---------[ Giovanni Zorzan ]---------[]
> []---------[ Agenzia Lumetel Scrl ]---------[]
> []---------[ giovanni@lumetel.it ]---------[]
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>