• Info
• Initial State
• View Source
• Run

DAV Maintenance

VS-D-3 DAV Properties

SQL/XML documents in DAV

Preliminaries

• The SQL query can be transformed into an XML document with xml_auto() for example.
• The SQL/XML documents are automatically generated resources, based on a SQL query.
• Two types of SQL/XML documents can be defined in the WebDAV repository: Persistent documents and Immediate transformation.

Persistent Documents

The persistent SQL/XML documents have the same behavior as text/xml documents:

• They have a mime type of text/xml, and have a content.
• The content can be refreshed with a scheduled event.
• The content is free-text indexed

Immediate Transformation

The SQL/XML documents with immediate transformation are formed as they are requested.

• The content is empty
• Hence the content is not free-text indexed

Properties

• Both resources have a property xml-sql. The value of the property is the SQL query string.
• If content length is zero and the xml-sql property is set, then the server will do an immediate transformation.
• Both resources have xml-sql-root, xml-sql-dtd, and xml-sql-schema properties (see also vs-d-2).

SQL/XML resource example

The example SQL script creates a few SQL/XML resources.

Click here for resources made in /DAV/vs_d_3/

View the source	Action
1. vs_d_3_sample.sql	Set the initial state
2. goto /DAV/vs_d_3/	Run