Are you using at least the 10g driver?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 12:18 AM To: [email protected] Subject: RE: Roller 2.3 - Oracle 9.2 Yes i am. I have fixed this issue already. There was a mistake in my hibernate.cfg.xml file. But i still have issues with the "server properties" page that is all empty. Eric -----Message d'origine----- De : George Daswani [mailto:[EMAIL PROTECTED] Envoyé : lundi 26 juin 2006 19:52 À : [email protected] Objet : RE: Roller 2.3 - Oracle 9.2 The Oracle dialect for the referrer performs the following sql select u.username,w.name,w.handle,sum(r.dayhits) as s from rolleruser u, website w, referer r where r.websiteid=w.id and w.userid=u.id and w.isenabled=1 and w.isactive=1 and rownum <= 10 group by u.username,w.name,w.handle order by s desc Are you able to execute the above SQL on oracle without error? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, June 23, 2006 2:21 AM To: [email protected] Subject: RE: Roller 2.3 - Oracle 9.2 Re. I copy here the exception i have when i try to go to the "Front page". Mey be it will give ideas to some of you. ERROR 2006-06-23 11:18:59,651 HibernateRefererManagerImpl:getDaysPopularWebsites - Getting popular websites java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:877 ) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2 513) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement. java:2857) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedS tatement.java:608) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedSt atement.java:536) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Del egatingPreparedStatement.java:92) at org.apache.roller.business.hibernate.HibernateRefererManagerImpl.getDays PopularWebsites(HibernateRefererManagerImpl.java:359) at org.apache.roller.presentation.MainPageAction$MainPageData.getPopularWeb sites(MainPageAction.java:105) at org.apache.jsp.main_jsp._jspService(main_jsp.java:197) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at ------------------------------------------------------------------------------------------- "Cette communication (y compris les pieces jointes) est reservee a l'usage exclusif du destinataire (des destinataires) et peut contenir des informations privilegiees, confidentielles, exemptees de divulgation selon la loi ou protegees par les droits d'auteur. Si vous n'etes pas un destinataire, toute utilisation, divulgation, distribution, reproduction, examen ou copie (totale ou partielle) est non-autorisee et peut etre illegale. Tout message electronique est susceptible d'alteration et son integrite ne peut etre assuree. Sanofi Pasteur decline toute responsabilite au titre de ce message s'il a ete modifie ou falsifie. Si vous n'etes pas destinataire de ce message, merci de le detruire immediatement et d'avertir l'expediteur de l'erreur de distribution et de la destruction du message. Merci. This transmission (including any attachments) is intended solely for the use of the addressee(s) and may contain confidential information including trade secrets which are privileged, confidential, exempt from disclosure under applicable law and/or subject to copyright. If you are not an intended recipient, any use, disclosure, distribution, reproduction, review or copying (either whole or partial) is unauthorized and may be unlawful. E-mails are susceptible to alteration and their integrity cannot be guaranteed.Sanofi Pasteur shall not be liable for this e-mail if modified or falsified. If you are not the intended recipient of this e-mail, please delete it immediately from your system and notify the sender of the wrong delivery and the mail deletion. Thank you." **********************************************************************
