eXist Support

Introduction

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 interface differences.

How to Configure the eXist Support in Oxygen

There are two notions you need to understand in order to configure the DB2 support in Oxygen:

  • Data Source
  • Connection

A data source defines all that is needed to have a connection to the database.

The data source drivers can be configured in the Data Source preferences page.

eXist Data Source Configuration Dialog

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/topics/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.

eXist Connection Configuration Dialog

For specific instructions on how to configure the connections, see the following topic in our Users Manual: http://www.oxygenxml.com/doc/ug-editor/topics/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.

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 it.

eXist XQuery Support

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.

WebDAV Support

Collection/resource management can also be done using WebDAV (see http://demo.exist-db.org/exist/webdav.xml#N101F3 , oxygenXML section).