java.sql.SQLException: ORA-00907: missing right parenthesis while deleting a document

[delbd <de...@oma.be>]

Hello.
I got this error while trying to remove a folder using the webdav protocol (the user logged in was admin, client application was konqueror)
I am using jakarta-slide 2.1

As you can guess, we are using the oracle store.

Exactly is what i did:
I entered, authed, in a folder and selected all content for remove. I hit the 'delete' button and confirm the list of file to konqueror.
It deletes well the only file of directory, but when i comes to subdirs it pops me a 'file does not exist' dialog (as far as i remember) 
pointing to the file i deleted. Ok. I refresh the page and file did disappear but folders not. So i reask to delete them. 
Now each time i try to deleted them i get a '404'. i get to consol to understand what happens and see that log.
I restarted the whole tomcat thing. My folders are still there, i still get the 404 while trying to delete them. But the i don't 
get that stack trace again. 

Let it be clear: i got that stack trace and now the db seems stucked!
I think this is quite worth investigations :s 
Any clues?

java.sql.SQLException: ORA-00907: missing right parenthesis

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
        at org.apache.slide.store.impl.rdbms.CommonRDBMSAdapter.revokePermission(CommonRDBMSAdapter.java:235)
        at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.revokePermission(AbstractRDBMSStore.java:479)
        at org.apache.slide.store.AbstractStore.revokePermission(AbstractStore.java:759)
        at org.apache.slide.store.ExtendedStore.revokePermission(ExtendedStore.java:658)
        at org.apache.slide.security.SecurityImpl.revokePermission(SecurityImpl.java:369)
        at org.apache.slide.macro.MacroImpl.deleteObject(MacroImpl.java:814)
        at org.apache.slide.macro.MacroImpl.delete(MacroImpl.java:524)
        at org.apache.slide.macro.MacroImpl.delete(MacroImpl.java:482)
        at org.apache.slide.webdav.method.DeleteMethod.executeRequest(DeleteMethod.java:156)
        at org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMethod.java:405)
        at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:155)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
        at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:534)

-- 
David Delbecq
Royal Meteorological Institute of Belgium 

---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org