XWiki P2P

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

XWiki P2P

jeremi joslin
hello,
i'm in china. And we need to work with a developpement team in france
for a school project on a wiki. But the web in our university is very
slow and it's a pain to access to french website.

Is it possible to setup a wiki server in china and one in france using
the XWiki P2P?

Jérémi
--
Blog: http://www.jeremi.info
LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
http://www.xwiki.org
skype: jeremi23 -- msn et gtalk : [hidden email]



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Error on Wiki

ikoga
I'm having problems with this error:

Error number 4001 in 4: Error while parsing velocity page Main.WebHome
Wrapped Exception: Invocation of method 'searchDocuments' in class
com.xpn.xwiki.api.XWiki threw exception class
com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while
searching documents with sql , BaseObject as obj where
obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
Wrapped Exception: could not execute query
<http://200.128.80.175:8080/medicoes-xwiki/bin/view/Main/WebHome>

Does anybody knows how to solve it?
Please, Help!




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: XWiki P2P

Ludovic Dubost-3
In reply to this post by jeremi joslin

It is possible but you will need some work to do the initial install for
the registry. It's actually more complex than what you need (xwiki to
xwiki replication)

Among issues:

- You need a registry to find the other wikis
- The current replication code probably needs some real testing.
- Also there is no scheduler yet to launch the replication regularly.

It would indeed be interesting to just setup xwiki to xwiki replication.

The P2P XWiki plugin is in the SVN repository.
http://svn.forge.objectweb.org/cgi-bin/viewcvs.cgi/xwiki/xwiki-clients/p2pxwiki/

See
http://www.xwiki.org/xwiki/bin/view/Dev/P2PXWiki


Ludovic

jeremi joslin a écrit :

> hello,
> i'm in china. And we need to work with a developpement team in france
> for a school project on a wiki. But the web in our university is very
> slow and it's a pain to access to french website.
>
> Is it possible to setup a wiki server in china and one in france using
> the XWiki P2P?
>
> Jérémi
> --
> Blog: http://www.jeremi.info
> LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
> http://www.xwiki.org
> skype: jeremi23 -- msn et gtalk : [hidden email]
>
>  
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error on Wiki

Ludovic Dubost
In reply to this post by ikoga

Hi Ivan,

This is not enough information about the error. Click on the link which
will show more information

Ludovic

Ivan Koji Koga a écrit :

> I'm having problems with this error:
>
> Error number 4001 in 4: Error while parsing velocity page Main.WebHome
> Wrapped Exception: Invocation of method 'searchDocuments' in class
> com.xpn.xwiki.api.XWiki threw exception class
> com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while
> searching documents with sql , BaseObject as obj where
> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
> Wrapped Exception: could not execute query
> <http://200.128.80.175:8080/medicoes-xwiki/bin/view/Main/WebHome>
>
> Does anybody knows how to solve it?
> Please, Help!
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  

--
Ludovic Dubost
XPertNet: http://www.xpertnet.fr/
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error on Wiki

ikoga
Clicking on the link appear many errors:

Error number 4001 in 4: Error while parsing velocity page Main.WebHome

Wrapped Exception: Invocation of method 'searchDocuments' in  class com.xpn.xwiki.api.XWiki threw exception class com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while searching documents with sql , BaseObject as obj where obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
Wrapped Exception: could not execute query
com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while parsing velocity page Main.WebHome
Wrapped Exception: Invocation of method 'searchDocuments' in  class com.xpn.xwiki.api.XWiki threw exception class com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while searching documents with sql , BaseObject as obj where obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
Wrapped Exception: could not execute query
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:131)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
        at com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
        at com.xpn.xwiki.XWiki.include(XWiki.java:1937)
        at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463)
        at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
        at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
        at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
        at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
        at com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
        at com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
        at com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
        at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
        at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
        at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
        at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
        at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
        at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806)
        at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87)
        at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219)
        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 com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
        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:856)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
        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(Thread.java:595)

Wrapped Exception:

com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while
searching documents with sql , BaseObject as obj where
obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
Wrapped Exception: could not execute query at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1881)
at
com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
at
com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585) at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at
org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585) at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
at
com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585) at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
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:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
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(Thread.java:595)

Wrapped Exception:

org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
pool failed at
org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:93)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:383)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:321)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:86)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1129)
at org.hibernate.loader.Loader.doQuery(Loader.java:373) at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
at org.hibernate.loader.Loader.doList(Loader.java:1562) at
org.hibernate.loader.Loader.list(Loader.java:1545) at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840) at
org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at
com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1867)
at
com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
at
com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585) at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at
org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585) at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
at
com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
at
com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585) at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
at
com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
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:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
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(Thread.java:595) Caused by:
java.sql.SQLException: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '?' at line 1 at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534) at
com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
at
com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309) at
com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281) at
org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:188)
at
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:792)
at
org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:87)
? 99 more

Does anybody can help me?

Thank's in advance!

Ivan K. Koga

Ludovic Dubost wrote:

>
> Hi Ivan,
>
> This is not enough information about the error. Click on the link
> which will show more information
>
> Ludovic
>
> Ivan Koji Koga a ?crit :
>
>> I'm having problems with this error:
>>
>> Error number 4001 in 4: Error while parsing velocity page
>> Main.WebHome Wrapped Exception: Invocation of method
>> 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception
>> class com.xpn.xwiki.XWikiException : Error number 3223 in 3:
>> Exception while searching documents with sql , BaseObject as obj
>> where obj.name=doc.fullName and obj.className='XWiki.ArticleClass'
>> and obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate
>> desc Wrapped Exception: could not execute query
>> <http://200.128.80.175:8080/medicoes-xwiki/bin/view/Main/WebHome>
>>
>> Does anybody knows how to solve it?
>> Please, Help!
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> --
>> You receive this message as a subscriber of the
>> [hidden email] mailing list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>
>------------------------------------------------------------------------
>
>
>--
>You receive this message as a subscriber of the [hidden email] mailing list.
>To unsubscribe: mailto:[hidden email]
>For general help: mailto:[hidden email]?subject=help
>ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  
>



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error on Wiki

Ludovic Dubost

It would be helpfull if you gave some more info about your environment
and what you did.
What works and what doesn't.

This looks like an incompatible database. Maybe the mysql version is bad..

Ludovic

Ivan Koji Koga a écrit :

> Clicking on the link appear many errors:
>
> Error number 4001 in 4: Error while parsing velocity page Main.WebHome
>
> Wrapped Exception: Invocation of method 'searchDocuments' in  class
> com.xpn.xwiki.api.XWiki threw exception class
> com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while
> searching documents with sql , BaseObject as obj where
> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
> Wrapped Exception: could not execute query
> com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while
> parsing velocity page Main.WebHome
> Wrapped Exception: Invocation of method 'searchDocuments' in  class
> com.xpn.xwiki.api.XWiki threw exception class
> com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while
> searching documents with sql , BaseObject as obj where
> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
> Wrapped Exception: could not execute query
>     at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:131)
>
>     at
> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>
>     at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>
>     at com.xpn.xwiki.XWiki.include(XWiki.java:1937)
>     at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463)
>     at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>     at java.lang.reflect.Method.invoke(Method.java:585)
>     at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>
>     at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>
>     at
> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>
>     at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>
>     at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>
>     at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>
>     at
> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>
>     at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>
>     at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
>
>     at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
>
>     at
> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
>
>     at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>     at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>     at java.lang.reflect.Method.invoke(Method.java:585)
>     at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
>     at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>
>     at
> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
>
>     at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>
>     at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>
>     at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>
>     at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806)
>     at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87)
>     at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219)
>     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
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>
>     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:856)
>
>     at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>
>     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(Thread.java:595)
>
> Wrapped Exception:
>
> com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while
> searching documents with sql , BaseObject as obj where
> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
> Wrapped Exception: could not execute query at
> com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1881)
> at
> com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
> at
> com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
> at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585) at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
> at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
> at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
> at
> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
> at
> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
> at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585) at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
> at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
> at
> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
> at
> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
> at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585) at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
> at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
> at
> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
> at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
> com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
> com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
> 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:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
> 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(Thread.java:595)
>
> Wrapped Exception:
>
> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement
> from pool failed at
> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:93)
> at
> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
> at
> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
> at
> org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:383)
> at
> org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:321)
> at
> org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:86)
> at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1129)
> at org.hibernate.loader.Loader.doQuery(Loader.java:373) at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
> at org.hibernate.loader.Loader.doList(Loader.java:1562) at
> org.hibernate.loader.Loader.list(Loader.java:1545) at
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840) at
> org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at
> com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1867)
> at
> com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
> at
> com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
> at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585) at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
> at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
> at
> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
> at
> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
> at
> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
> at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585) at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
> at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
> at
> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
> at
> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
> at
> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
> at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151) at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585) at
> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
> at
> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
> at
> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
> at
> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
> at
> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
> at
> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
> at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
> com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
> com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
> 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:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
> 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(Thread.java:595) Caused by:
> java.sql.SQLException: You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near '?' at line 1 at
> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534) at
> com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
> at
> com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
> at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309) at
> com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281) at
> org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:188)
> at
> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:792)
> at
> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:87)
> … 99 more
>
> Does anybody can help me?
>
> Thank's in advance!
>
> Ivan K. Koga
>
> Ludovic Dubost wrote:
>
>>
>> Hi Ivan,
>>
>> This is not enough information about the error. Click on the link
>> which will show more information
>>
>> Ludovic
>>
>> Ivan Koji Koga a écrit :
>>
>>> I'm having problems with this error:
>>>
>>> Error number 4001 in 4: Error while parsing velocity page
>>> Main.WebHome Wrapped Exception: Invocation of method
>>> 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception
>>> class com.xpn.xwiki.XWikiException : Error number 3223 in 3:
>>> Exception while searching documents with sql , BaseObject as obj
>>> where obj.name=doc.fullName and obj.className='XWiki.ArticleClass'
>>> and obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate
>>> desc Wrapped Exception: could not execute query
>>> <http://200.128.80.175:8080/medicoes-xwiki/bin/view/Main/WebHome>
>>>
>>> Does anybody knows how to solve it?
>>> Please, Help!
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>>
>>> --
>>> You receive this message as a subscriber of the
>>> [hidden email] mailing list.
>>> To unsubscribe: mailto:[hidden email]
>>> For general help: mailto:[hidden email]?subject=help
>>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> --
>> You receive this message as a subscriber of the
>> [hidden email] mailing list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>>  
>>
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  

--
Ludovic Dubost
XPertNet: http://www.xpertnet.fr/
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost AIM: nvludo Yahoo: ludovic




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error on Wiki

ikoga
Hi,

My Mysql Database is on version 4.1.14-0. I think this version is
compatible, doesn't it?

I'm using jakarta-tomcat-5.5.9

The search engine, What's New, isn't working too.

Appear like the same error:

Search
-----------------------------------------------------------------------------------
Error number 4001 in 4: Error while parsing velocity page Main.WebSearch
Wrapped Exception: Invocation of method 'searchDocuments' in class
com.xpn.xwiki.api.XWiki threw exception class
com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while
searching documents with sql where doc.web like '%e%' or doc.name like
'%e%' or doc.content like '%e%' order by doc.date desc Wrapped
Exception: could not execute query
The Comments are working, Attachments, page edition.
I'm new on xwiki and i don't know
----------------------------------------------------------------------------------
What's New
----------------------------------------------------------------------------------
Error number 4001 in 4: Error while parsing velocity page Main.WhatsNew
Wrapped Exception: Invocation of method 'searchDocuments' in class
com.xpn.xwiki.api.XWiki threw exception class
com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while
searching documents with sql where doc.name <> 'WhatsNew' order by
doc.date desc Wrapped Exception: could not execute query
----------------------------------------------------------------------------------



Ludovic Dubost wrote:

>
> It would be helpfull if you gave some more info about your environment
> and what you did.
> What works and what doesn't.
>
> This looks like an incompatible database. Maybe the mysql version is
> bad..
>
> Ludovic
>
> Ivan Koji Koga a ?crit :
>
>> Clicking on the link appear many errors:
>>
>> Error number 4001 in 4: Error while parsing velocity page Main.WebHome
>>
>> Wrapped Exception: Invocation of method 'searchDocuments' in  class
>> com.xpn.xwiki.api.XWiki threw exception class
>> com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception
>> while searching documents with sql , BaseObject as obj where
>> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
>> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
>> Wrapped Exception: could not execute query
>> com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while
>> parsing velocity page Main.WebHome
>> Wrapped Exception: Invocation of method 'searchDocuments' in  class
>> com.xpn.xwiki.api.XWiki threw exception class
>> com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception
>> while searching documents with sql , BaseObject as obj where
>> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
>> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
>> Wrapped Exception: could not execute query
>>     at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:131)
>>
>>     at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>
>>     at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>
>>     at com.xpn.xwiki.XWiki.include(XWiki.java:1937)
>>     at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463)
>>     at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>>     at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>     at java.lang.reflect.Method.invoke(Method.java:585)
>>     at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>
>>     at
>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>
>>     at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>
>>     at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>
>>     at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>
>>     at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>
>>     at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
>>
>>     at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
>>
>>     at
>> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
>>
>>     at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>     at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>
>>     at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>
>>     at java.lang.reflect.Method.invoke(Method.java:585)
>>     at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
>>
>>     at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>
>>     at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>
>>     at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>
>>     at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806)
>>     at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87)
>>     at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219)
>>     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
>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>>
>>     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:856)
>>
>>     at
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>
>>     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(Thread.java:595)
>>
>> Wrapped Exception:
>>
>> com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while
>> searching documents with sql , BaseObject as obj where
>> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
>> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
>> Wrapped Exception: could not execute query at
>> com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1881)
>> at
>> com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
>> at
>> com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
>> at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585) at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>> at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
>> at
>> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
>> at
>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>> at
>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>> at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585) at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>> at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>> at
>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
>> at
>> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
>> at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585) at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>> at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>> at
>> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>> at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
>> com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
>> com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>> 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:856)
>> at
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>> 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(Thread.java:595)
>>
>> Wrapped Exception:
>>
>> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement
>> from pool failed at
>> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:93)
>> at
>> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
>> at
>> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
>> at
>> org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:383)
>> at
>> org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:321)
>> at
>> org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:86)
>> at
>> org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1129)
>> at org.hibernate.loader.Loader.doQuery(Loader.java:373) at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
>> at org.hibernate.loader.Loader.doList(Loader.java:1562) at
>> org.hibernate.loader.Loader.list(Loader.java:1545) at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
>> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840) at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at
>> com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1867)
>> at
>> com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
>> at
>> com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
>> at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585) at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>> at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
>> at
>> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
>> at
>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>> at
>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>> at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585) at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>> at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>> at
>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
>> at
>> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
>> at
>> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
>> at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>> at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>> at java.lang.reflect.Method.invoke(Method.java:585) at
>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>> at
>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>> at
>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>> at
>> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
>> at
>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>> at
>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>> at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
>> com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
>> com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>> 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:856)
>> at
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>> 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(Thread.java:595) Caused by:
>> java.sql.SQLException: You have an error in your SQL syntax; check
>> the manual that corresponds to your MySQL server version for the
>> right syntax to use near '?' at line 1 at
>> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) at
>> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534) at
>> com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
>> at
>> com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
>> at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
>> at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
>> at
>> org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:188)
>> at
>> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:792)
>> at
>> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:87)
>> ? 99 more
>>
>> Does anybody can help me?
>>
>> Thank's in advance!
>>
>> Ivan K. Koga
>>
>> Ludovic Dubost wrote:
>>
>>>
>>> Hi Ivan,
>>>
>>> This is not enough information about the error. Click on the link
>>> which will show more information
>>>
>>> Ludovic
>>>
>>> Ivan Koji Koga a ?crit :
>>>
>>>> I'm having problems with this error:
>>>>
>>>> Error number 4001 in 4: Error while parsing velocity page
>>>> Main.WebHome Wrapped Exception: Invocation of method
>>>> 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception
>>>> class com.xpn.xwiki.XWikiException : Error number 3223 in 3:
>>>> Exception while searching documents with sql , BaseObject as obj
>>>> where obj.name=doc.fullName and obj.className='XWiki.ArticleClass'
>>>> and obj.name<>'XWiki.ArticleClassTemplate' order by
>>>> doc.creationDate desc Wrapped Exception: could not execute query
>>>> <http://200.128.80.175:8080/medicoes-xwiki/bin/view/Main/WebHome>
>>>>
>>>> Does anybody knows how to solve it?
>>>> Please, Help!
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>> --
>>>> You receive this message as a subscriber of the
>>>> [hidden email] mailing list.
>>>> To unsubscribe: mailto:[hidden email]
>>>> For general help: mailto:[hidden email]?subject=help
>>>> ObjectWeb mailing lists service home page:
>>>> http://www.objectweb.org/wws
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>>
>>> --
>>> You receive this message as a subscriber of the
>>> [hidden email] mailing list.
>>> To unsubscribe: mailto:[hidden email]
>>> For general help: mailto:[hidden email]?subject=help
>>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>>>  
>>>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> --
>> You receive this message as a subscriber of the
>> [hidden email] mailing list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>>  
>
>
>
>------------------------------------------------------------------------
>
>
>--
>You receive this message as a subscriber of the [hidden email] mailing list.
>To unsubscribe: mailto:[hidden email]
>For general help: mailto:[hidden email]?subject=help
>ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  
>



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error on Wiki

Ludovic Dubost-3

Hi,

I heard of a problem with MySQL 4.1.12 and the user downgraded to 4.1.11
and it worked
It might be the same issue.

We need to investigate this. We should file a bug on this on
http://jira.xwiki.org
Can you confirm the issue and file the problem

Ludovic

Ivan Koji Koga a écrit :

> Hi,
>
> My Mysql Database is on version 4.1.14-0. I think this version is
> compatible, doesn't it?
>
> I'm using jakarta-tomcat-5.5.9
>
> The search engine, What's New, isn't working too.
>
> Appear like the same error:
>
> Search
> -----------------------------------------------------------------------------------
>
> Error number 4001 in 4: Error while parsing velocity page
> Main.WebSearch Wrapped Exception: Invocation of method
> 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception
> class com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception
> while searching documents with sql where doc.web like '%e%' or
> doc.name like '%e%' or doc.content like '%e%' order by doc.date desc
> Wrapped Exception: could not execute query
> The Comments are working, Attachments, page edition.
> I'm new on xwiki and i don't know
> ----------------------------------------------------------------------------------
>
> What's New
> ----------------------------------------------------------------------------------
>
> Error number 4001 in 4: Error while parsing velocity page
> Main.WhatsNew Wrapped Exception: Invocation of method
> 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception
> class com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception
> while searching documents with sql where doc.name <> 'WhatsNew' order
> by doc.date desc Wrapped Exception: could not execute query
> ----------------------------------------------------------------------------------
>
>
>
>
> Ludovic Dubost wrote:
>
>>
>> It would be helpfull if you gave some more info about your
>> environment and what you did.
>> What works and what doesn't.
>>
>> This looks like an incompatible database. Maybe the mysql version is
>> bad..
>>
>> Ludovic
>>
>> Ivan Koji Koga a écrit :
>>
>>> Clicking on the link appear many errors:
>>>
>>> Error number 4001 in 4: Error while parsing velocity page Main.WebHome
>>>
>>> Wrapped Exception: Invocation of method 'searchDocuments' in  class
>>> com.xpn.xwiki.api.XWiki threw exception class
>>> com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception
>>> while searching documents with sql , BaseObject as obj where
>>> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
>>> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
>>> Wrapped Exception: could not execute query
>>> com.xpn.xwiki.XWikiException: Error number 4001 in 4: Error while
>>> parsing velocity page Main.WebHome
>>> Wrapped Exception: Invocation of method 'searchDocuments' in  class
>>> com.xpn.xwiki.api.XWiki threw exception class
>>> com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception
>>> while searching documents with sql , BaseObject as obj where
>>> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
>>> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc
>>> Wrapped Exception: could not execute query
>>>     at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:131)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>>
>>>     at com.xpn.xwiki.XWiki.include(XWiki.java:1937)
>>>     at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463)
>>>     at com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451)
>>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>     at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>
>>>     at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>
>>>     at java.lang.reflect.Method.invoke(Method.java:585)
>>>     at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>>
>>>     at
>>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
>>>
>>>     at
>>> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
>>>
>>>     at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
>>>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>     at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>>
>>>     at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>>
>>>     at java.lang.reflect.Method.invoke(Method.java:585)
>>>     at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
>>>
>>>     at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>>
>>>     at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>>
>>>     at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806)
>>>     at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87)
>>>     at
>>> com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219)
>>>     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
>>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>>>
>>>     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:856)
>>>
>>>     at
>>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>>
>>>     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(Thread.java:595)
>>>
>>> Wrapped Exception:
>>>
>>> com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception
>>> while searching documents with sql , BaseObject as obj where
>>> obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and
>>> obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate
>>> desc Wrapped Exception: could not execute query at
>>> com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1881)
>>> at
>>> com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
>>> at
>>> com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
>>> at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585) at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
>>> at
>>> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>> at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
>>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
>>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585) at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
>>> at
>>> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
>>> at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585) at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>> at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
>>> com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
>>> com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
>>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>>> 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:856)
>>> at
>>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>> 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(Thread.java:595)
>>>
>>> Wrapped Exception:
>>>
>>> org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement
>>> from pool failed at
>>> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:93)
>>> at
>>> org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
>>> at
>>> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
>>> at
>>> org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:383)
>>> at
>>> org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:321)
>>> at
>>> org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:86)
>>> at
>>> org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1129)
>>> at org.hibernate.loader.Loader.doQuery(Loader.java:373) at
>>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
>>> at org.hibernate.loader.Loader.doList(Loader.java:1562) at
>>> org.hibernate.loader.Loader.list(Loader.java:1545) at
>>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at
>>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
>>> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840) at
>>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at
>>> com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1867)
>>> at
>>> com.xpn.xwiki.store.XWikiDefaultStore.searchDocumentsNames(XWikiDefaultStore.java:38)
>>> at
>>> com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:162)
>>> at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:234) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585) at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:327)
>>> at
>>> org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:131)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>> at com.xpn.xwiki.XWiki.include(XWiki.java:1937) at
>>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:463) at
>>> com.xpn.xwiki.api.XWiki.includeForm(XWiki.java:451) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585) at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:172)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:114)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.render(XWikiVelocityRenderer.java:87)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:116)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderText(XWikiRenderingEngine.java:93)
>>> at
>>> com.xpn.xwiki.render.XWikiRenderingEngine.renderDocument(XWikiRenderingEngine.java:85)
>>> at
>>> com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:220)
>>> at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:151)
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>>> at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>> at java.lang.reflect.Method.invoke(Method.java:585) at
>>> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:267)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:197)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:175)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:220)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:55)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:89)
>>> at
>>> org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:230)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:223)
>>> at
>>> com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:125)
>>> at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:806) at
>>> com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:87) at
>>> com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:219) 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
>>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>>> 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:856)
>>> at
>>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>> 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(Thread.java:595) Caused by:
>>> java.sql.SQLException: You have an error in your SQL syntax; check
>>> the manual that corresponds to your MySQL server version for the
>>> right syntax to use near '?' at line 1 at
>>> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) at
>>> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534) at
>>> com.mysql.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1485)
>>> at
>>> com.mysql.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:151)
>>> at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1309)
>>> at com.mysql.jdbc.Connection.prepareStatement(Connection.java:1281)
>>> at
>>> org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:188)
>>> at
>>> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:792)
>>> at
>>> org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:87)
>>> … 99 more
>>>
>>> Does anybody can help me?
>>>
>>> Thank's in advance!
>>>
>>> Ivan K. Koga
>>>
>>> Ludovic Dubost wrote:
>>>
>>>>
>>>> Hi Ivan,
>>>>
>>>> This is not enough information about the error. Click on the link
>>>> which will show more information
>>>>
>>>> Ludovic
>>>>
>>>> Ivan Koji Koga a écrit :
>>>>
>>>>> I'm having problems with this error:
>>>>>
>>>>> Error number 4001 in 4: Error while parsing velocity page
>>>>> Main.WebHome Wrapped Exception: Invocation of method
>>>>> 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception
>>>>> class com.xpn.xwiki.XWikiException : Error number 3223 in 3:
>>>>> Exception while searching documents with sql , BaseObject as obj
>>>>> where obj.name=doc.fullName and obj.className='XWiki.ArticleClass'
>>>>> and obj.name<>'XWiki.ArticleClassTemplate' order by
>>>>> doc.creationDate desc Wrapped Exception: could not execute query
>>>>> <http://200.128.80.175:8080/medicoes-xwiki/bin/view/Main/WebHome>
>>>>>
>>>>> Does anybody knows how to solve it?
>>>>> Please, Help!
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> You receive this message as a subscriber of the
>>>>> [hidden email] mailing list.
>>>>> To unsubscribe: mailto:[hidden email]
>>>>> For general help: mailto:[hidden email]?subject=help
>>>>> ObjectWeb mailing lists service home page:
>>>>> http://www.objectweb.org/wws
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>>
>>>> --
>>>> You receive this message as a subscriber of the
>>>> [hidden email] mailing list.
>>>> To unsubscribe: mailto:[hidden email]
>>>> For general help: mailto:[hidden email]?subject=help
>>>> ObjectWeb mailing lists service home page:
>>>> http://www.objectweb.org/wws
>>>>  
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>>
>>>
>>> --
>>> You receive this message as a subscriber of the
>>> [hidden email] mailing list.
>>> To unsubscribe: mailto:[hidden email]
>>> For general help: mailto:[hidden email]?subject=help
>>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>>>  
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> --
>> You receive this message as a subscriber of the
>> [hidden email] mailing list.
>> To unsubscribe: mailto:[hidden email]
>> For general help: mailto:[hidden email]?subject=help
>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>>  
>>
>
>
> ------------------------------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>  



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws