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:[EMAIL PROTECTED]] >Sent: Tuesday, January 29, 2002 5:17 PM >To: [EMAIL PROTECTED] >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 ]---------[] > []---------[ [EMAIL PROTECTED] ]---------[] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
