This tutorial explains how to configure the eXist support in oXygen XML
Editor, browse and edit resources, as well as running XQuery interrogations.
The tutorial assumes that you have a basic knowledge of databases, XML
technologies, and of oXygen XML Editor tool. The explanations and screenshots are
given for the standalone version of oXygen XML Editor. However, the same set of
features are available in the Eclipse plugin version of the product with minor
How to Configure the eXist Support in oXygen
There are two notions you need to understand in order to configure the DB2 support
A data source defines all that is needed to have a connection to the
The data source drivers can be configured in the Data Source
For specific instructions on how to configure the data source drivers, see the
following topic in our Users Manual: http://www.oxygenxml.com/doc/ug-editor/tasks/configure-exist-datasource.html#configure-exist-datasource.
Once you have created the data source you may proceed further by defining one or
more connections. The connections can be configured in the same Data
Source preferences page.
For specific instructions on how to configure the connections, see the following
topic in our Users Manual: http://www.oxygenxml.com/doc/ug-editor/tasks/configure-exist-connection.html#configure-exist-connection.
Sometimes you need to work with two database servers (for example, a development
sever and a production server) so it makes sense to define a connection on each
database server to be further used when executing XQuery or browsing/editing the
database resources. If the two database servers have the same version, you only need
to configure a data source and add two connections for it.
Data Source Explorer View
Once you finish the configuration of the connection, you can browse the database
content using the Data Source Explorer view from the Database perspective.
XQuery Execution Support
eXist supports XQuery interrogations over the stored XML content (for example, you
can create an XQuery to generate a report with the billing contact data from the
latest purchase notifications). You can open an XQuery document (an XQuery template is
available from the File/New menu), configure the transformation scenario to match the
eXist connection for the transformer field, write the XQuery, and then execute
XQuery Validation Support
You can configure eXist as main validator for XQuery files in the
XQuery preferences page (Options / Preferences / XML /
XSLT/FO/XQuery / XQuery). Additionally, you can set the other options. You will now
benefit from the automatic validation feature and you can use the Validate button to
manually get a list of validation errors.
Collection/resource management can also be done using WebDAV (see http://demo.exist-db.org/exist/webdav.xml#N101F3 , oxygenXML section).