It seems that for each of those errors, the exception is the same.
And no difference if i use the thin driver.
Eric
WARN 2006-06-22 14:29:15,631 JDBCExceptionReporter:logExceptions - SQL Error:
933, SQLState: 42000
ERROR 2006-06-22 14:29:15,631 JDBCExceptionReporter:logExceptions - ORA-00933:
SQL command not properly ended
ERROR 2006-06-22 14:29:15,631 HibernateWeblogManagerImpl:getComments -
org.hibernate.exception.SQLGrammarException: could not execute query
ERROR 2006-06-22 14:29:15,631 StandardWrapperValve:invoke - Servlet.service()
for servlet action threw exception
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at
org.apache.roller.business.hibernate.HibernateWeblogManagerImpl.getComments(HibernateWeblogManagerImpl.java:818)
at
org.apache.roller.presentation.weblog.actions.CommentManagementAction$CommentManagementPageModel.<init>(CommentManagementAction.java:280)
at
org.apache.roller.presentation.weblog.actions.CommentManagementAction.query(CommentManagementAction.java:96)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:83)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.roller.presentation.filters.PersistenceSessionFilter.doFilter(PersistenceSessionFilter.java:60)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.securechannel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:138)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:216)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:195)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnforcementFilter.java:121)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilter.java:104)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2337)
at
oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:1258)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2513)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2857)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:536)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 71 more
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 22 juin 2006 10:42
À : [email protected]
Objet : RE: Issue with Oracle
A lot of things do not work with my installation :
- listing entries
- listing comments
- updating global settings
- display the front page of my installation (main.do)
- listing categories of a blog
-----Message d'origine-----
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 22 juin 2006 09:58
À : [email protected]
Objet : Issue with Oracle
Hi all,
I try to install Roller with Oracle 9.2 for database.
Installation/start -> ok
First registration -> ok
Then i try to make some change in the global administration (enabling upload,
comments,...) When i save, it says "ok", but when the page is refreshed, all
the checkboxes are empty (only text fields are saved).
No exception in logs...
Any idea?
Eric
-------------------------------------------------------------------------------------------
"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."
**********************************************************************
-------------------------------------------------------------------------------------------
"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."
**********************************************************************
-------------------------------------------------------------------------------------------
"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."
**********************************************************************
-------------------------------------------------------------------------------------------
"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."
**********************************************************************
-------------------------------------------------------------------------------------------
"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."
**********************************************************************
