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 ]---------[]
[]---------[ [EMAIL PROTECTED] ]---------[]
