Chapter 10. XA Tutorial
Abstract
This tutorial describes how to define and build a transactional route involving two XA resources (a JMS resource and a JDBC resource), based on the Apache Aries transaction manager in the OSGi container. For the purposes of illustration, the tutorial uses the Apache Derby database, which provides the JDBC XA resource.
10.1. Install Apache Derby
Overview
For this tutorial, you need an installation of the Apache Derby database, which is an open source database that supports XA transactions. In particular, you will need to use the
ij command-line utility later in the tutorial to create a database schema.
Downloading
Download the latest binary distribution of Apache Derby,
db-derby-Version-bin.zip, from the Apache Derby download page:
http://db.apache.org/derby/derby_downloads.html
Note
The same binary distribution is used both for Windows and *NIX operating systems.
Installing
To install Apache Derby, use an archive utility to extract the binary distribution into a convenient directory (for example,
C:\Program Files on Windows, or /usr/local on *NIX).
Environment variables
To gain access to the Derby command-line utilities, add the Derby
bin directory to your PATH variable.
On Windows, you could use a batch script like the following:
REM Set Apache Derby environment on Windows SET DERBY_HOME=DerbyInstallDir SET PATH=%DERBY_HOME%\bin;%PATH%
On *NIX, you could use a bash script like the following:
# Set Apache Derby environment on *NIX DERBY_HOME=DerbyInstallDir export PATH=$DERBY_HOME/bin:$PATH
