Hello,
We have got a problem here to remove a role using a webdav client.
When we select any role and ask for deletion, we get this in console:
18 Apr 2005 07:15:12 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter
- ERROR - SQL error 2292 on /roles/PublicationManager: ORA-02292: integrity
constraint (DIRECTION.SYS_C0035428) violated - child record found
java.sql.SQLException: ORA-02292: integrity constraint
(DIRECTION.SYS_C0035428) violated - child record found
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.removeObject(CommonRDBMSAdapter.java:117)
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.removeObject(AbstractRDBMSStore.java:455)
at
org.apache.slide.store.AbstractStore.removeObject(AbstractStore.java:707)
at
org.apache.slide.store.ExtendedStore.removeObject(ExtendedStore.java:623)
at
org.apache.slide.structure.StructureImpl.remove(StructureImpl.java:568)
at org.apache.slide.macro.MacroImpl.deleteObject(MacroImpl.java:836)
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:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:141)
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:214)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
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:825)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
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:534)
http-8081-Processor12, 18-Apr-2005 07:15:11, root, DELETE, 207 "Multi-Status",
707 ms, /roles/PublicationManager
Domain config is as follow:
<store name="OracleStore">
<nodestore
classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter
name="adapter">org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter</parameter>
<parameter
name="driver">oracle.jdbc.driver.OracleDriver</parameter>
<parameter
name="url">jdbc:oracle:thin:@delphi.oma.be:1521:rmidb</parameter>
<parameter
name="user">@@config.slide.db.user@@</parameter>
<parameter
name="password">@@config.slide.db.password@@</parameter>
<parameter
name="dbcpPooling">true</parameter>
<parameter
name="maxPooledConnections">5</parameter>
<!-- I got problem with this option
under Oracle. So I desactivated it.
<parameter
name="isolation">SERIALIZABLE</parameter>
-->
<parameter
name="compress">false</parameter>
</nodestore>
<securitystore>
<reference store="nodestore" />
</securitystore>
<lockstore>
<reference store="nodestore" />
</lockstore>
<revisiondescriptorsstore>
<reference store="nodestore" />
</revisiondescriptorsstore>
<revisiondescriptorstore>
<reference store="nodestore" />
</revisiondescriptorstore>
<contentstore>
<reference store="nodestore" />
</contentstore>
</store>
<scope match="/" store="OracleStore"/>
</definition>
The roles objects, of type collection, does not have any child node.
Can someone explain us what we messed up when trying to delete the roles?
--
David Delbecq
Royal Meteorological Institute of Belgium
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
