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:gdaswani esri.com]
Envoyé : lundi 26 juin 2006 19:52
À : roller-userincubator.apache.org
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: Eric.Bardouxsanofipasteur.com
[mailto:Eric.Bardouxsanofipasteur.com]
Sent: Friday, June 23, 2006 2:21 AM
To: roller-userincubator.apache.org
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(TTC7Proto
col.java:877
)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStat
ement.java:2
513)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac
leStatement.
java:2857)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Ora
clePreparedS
tatement.java:608)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(Orac
lePreparedSt
atement.java:536)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.exec
uteQuery(Del
egatingPreparedStatement.java:92)
at
org.apache.roller.business.hibernate.HibernateRefererManager
Impl.getDays
PopularWebsites(HibernateRefererManagerImpl.java:359)
at
org.apache.roller.presentation.MainPageAction$MainPageData.g
etPopularWeb
sites(MainPageAction.java:105)
at org.apache.jsp.main_jsp._jspService(main_jsp.java:197)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.ja
va: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."
************************************************************
**********
|