Products

DataDirect XQuery® Relational Database Support Summary

DataDirect XQuery® provides support for accessing the data contained in many popular relational databases, directly as XML using the XQuery language. Supported databases include Oracle, IBM, Microsoft, MySQL, Informix, Sybase and PostgreSQL. A list of supported versions of various RDBMS is posted here, but check back often as we're adding more database support. Comprehensive support for all major relational databases in DataDirect XQuery® simplifies application development that involves integrating relational data and XML by providing a powerful and easy way to go from a relational database to XML, as well as XML to relational database.

Oracle XQuery Support

DataDirect XQuery® offers support for the following versions of Oracle:

Oracle 11g
Oracle 10g R1-R2 (10.1-10.2)
Oracle 9i R1-R2

Microsoft SQL Server XQuery Support

DataDirect XQuery® offers support for the following versions of Microsoft SQL Server:

MS SQL Server 2005 (including service pack 1)
MS SQL Server 2000 (including service packs 1, 2, 3a, and 4)
MS SQL Server 2000 Desktop Engine (MSDE 2000)
MS SQL Server 2000 Enterprise Edition (64-bit)

Sybase ASE XQuery Support

DataDirect XQuery® offers support for the following versions of Sybase ASE:

Sybase Adaptive Server Enterprise 12.5.1, 12.5.2, 12.5.3, 15.0

IBM DB2 XQuery Support

DataDirect XQuery® offers support for the following versions of IBM DB2:

DB2 UDB v8.x, v9.1 for Linux, UNIX, and Windows
DB2 UDB v8.1, v9 for z/OS
DB2 UDB V5R2, V5R3 for iSeries

MySQL XQuery Support

DataDirect XQuery® offers support for the following versions of MySQL:

MySQL Enterprise, 5.0.x

Informix XQuery Support

DataDirect XQuery® offers support for the following versions of Informix:

Informix 9.4 & 10

PostgreSQL XQuery Support

DataDirect XQuery® offers support for the following versions of PostgreSQL:

PostgreSQL 8.1 & 8.2.**

* Requires the MySQL Connector/J driver.
**Requires the PostgreSQL JDBC driver.

Last Updated: January 8, 2008

Next: "Oracle"

Supported Databases
(Table of Contents)

Database Support Home

Relational

Database Connection Pooling

DataDirect XQuery provides connection pooling at the JDBC level by integrating with your application server's JDBC pool manager, allowing you to leverage any connection pooling you may be using with other JDBC applications.

See JDBC Connection Pooling Servlet for an example of implementing a JDBC connection pool in DataDirect XQuery.