webdav and xdb, xml-files are automatically deleted (or hidden)
604709Jun 20 2012 — edited Jun 25 2012Hi All.
In our project we have mounted webdav from a Linux box against an IBM database server running AIX and Oracle 11g.
The file system on the Linux box is mounted to the xdb-schema on the dbserver.
When placing xml-files into the database through the webdav-catalogue on the Linux-box the files are copied over, but almost immediatly removed (or hidden) from the target directory in the database.
I´m thinking there might be a trigger that tries to validate the xml-file against an xsd that isn´t registered in XDB. The reason for this is that when suffixing these files with something other than .xml the files are kept visible to all users.
What I´d like to know is how to disable this check/trigger, and which trigger does this.
Can anybody tell me if my assumtion is correct, and if yes, how to disable this checking?
Our users in the project will also be given access to folders through this webdav mount, and they will use this as a storage space for other xml-files as well. Files we do not have xsd´s for. Another function for this webdav directory is to serve as a source directory for ODI, and ODI validates the files against the xsd when transferring data to the database, so we don´t need this extra validation in the database.
Thanks,
Bob