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
