Red Hat Summit Red Hat SummitSupportConsoleDevelopersStart a trialContact

10.5. Deploy and Run the Transactional Route

Overview
Copy link

After creating the Derby database instance, you are ready to deploy the OSGi bundles into the container and test the route, as described here.

Steps to deploy and run the transactional route
Copy link

Perform the following steps to deploy and run the transactional route in the Red Hat JBoss Fuse OSGi container:
  1. Create the Derby database instance for the tutorial and create the accounts table, as follows:
    1. Open a command prompt and change directory to the Derby system directory that you specified earlier (that is, the value of the derby.system.home system property).
    2. Start the Derby database client utility, ij, by entering the following command: 
      ij
      Copy to Clipboard Toggle word wrap
      Note
      By default, ij takes the current working directory to be the Derby system directory.
    3. Create the txXaTutorial database instance, by entering the following ij command: 
      ij> CONNECT 'jdbc:derby:txXaTutorial;create=true';
      Copy to Clipboard Toggle word wrap
    4. Create the accounts table and create two sample row entries, by entering the following sequence of ij commands: 
      ij> CREATE TABLE accounts (name VARCHAR(50), amount INT);

ij> INSERT INTO accounts (name,amount) VALUES ('Major Clanger',2000);

ij> INSERT INTO accounts (name,amount) VALUES ('Tiny Clanger',100);
      Copy to Clipboard Toggle word wrap
    5. Exit ij, by entering the following command (don't forget the semicolon): 
      ij> EXIT;
      Copy to Clipboard Toggle word wrap
  2. Open a new command prompt and start the JBoss Fuse OSGi container by entering the following command: 
    ./fuse
    Copy to Clipboard Toggle word wrap
  3. Install the transaction feature into the OSGi container. Enter the following console command: 
    JBossFuse:karaf@root> features:install transaction
    Copy to Clipboard Toggle word wrap
  4. Install the spring-jdbc feature into the OSGi container. Enter the following console command: 
    JBossFuse:karaf@root> features:install spring-jdbc
    Copy to Clipboard Toggle word wrap
  5. Install the derby bundle into the OSGi container. Enter the following console command, replacing the bundle version with whatever version of Derby you are using: 
    JBossFuse:karaf@root> install mvn:org.apache.derby/derby/10.10.1.1
    Copy to Clipboard Toggle word wrap
  6. Install and start the derby-ds bundle (assuming that you have already built the bundle, as described in Section 10.3, “Define a Derby Datasource”) by entering the following console command: 
    JBossFuse:karaf@root> install -s mvn:org.fusesource.example/derby-ds/1.0-SNAPSHOT
    Copy to Clipboard Toggle word wrap
  7. To check that the datasources have been successfully exported from the derby-ds bundle, list the derby-ds services using the osgi:ls command. For example, given that BundleID is the bundle ID for the derby-ds bundle, you would enter the following console command: 
    JBossFuse:karaf@root> osgi:ls BundleID
    Copy to Clipboard Toggle word wrap
    Amongst the exported services, you should see an entry like the following: 
    ----
aries.xa.aware = true
aries.xa.name = derbyDS
datasource.name = derbyXADB
objectClass = javax.sql.DataSource
osgi.service.blueprint.compname = derbyXADataSource
service.id = 424
----
    Copy to Clipboard Toggle word wrap
    This is the wrapped XA datasource (recognizable from the aries.xa.aware = true setting), which is automatically created by the Aries wrapper feature (see Apache Aries Auto-Enlisting XA Wrapper).
  8. Install and start the tx-xa bundle, by entering the following console command: 
    JBossFuse:karaf@root> install -s mvn:org.fusesource.example/tx-xa
    Copy to Clipboard Toggle word wrap
  9. Create a file called giro1.xml in any convenient directory and use a text editor to add the following message contents to it: 
    <transaction>
  <transfer>
    <sender>Major Clanger</sender>
    <receiver>Tiny Clanger</receiver>
    <amount>90</amount>
  </transfer>
</transaction>
    Copy to Clipboard Toggle word wrap
    Now copy giro1.xml into the PathNameToMsgDir directory you created earlier (see Section 10.4, “Define a Transactional Route”). The giro1.xml file should disappear immediately after it is copied, because the PathNameToMsgDir is being monitored by the feeder route.
  10. Use the JMX console to see what has happened to the message in giro1.xml. Open a new command prompt and enter the following command (provided with the standard JDK): 
    jconsole
    Copy to Clipboard Toggle word wrap
    In the JConsole: New Connection screen, select the org.apache.karaf.main.Main local process and click Connect.
  11. Click on the MBean tab and use the tree in the left-hand column to navigate to org.apache.activemq | TxXaDemo | Queue | statusLog | Operations, as shown in the following screenshot.

    Figure 10.1. JMX Operations Supported by the statusLog Queue

    JMX Operations Supported by the statusLog Queue
    View larger image
    JMX Operations Supported by the statusLog Queue
  12. Now in the right hand pane of the JConsole window, click browse (the version of the method that takes no arguments). The Operation return value dialog pops up as shown , which enables you to browse all of the messages currently pending in the statusLog queueue.

    Figure 10.2. JMX Browsing the statusLog Queue

    JMX Browsing the statusLog Queue
    View larger image
    JMX Browsing the statusLog Queue
    In the example shown here, there is just one message in the queue. If you scroll down, you can see the Text field, which holds the body of the JMS message. The body contains the most recent result of calling the AccountService.dumpTable() method (which is called in the last step of the transactional route).
  13. You can also force a transaction rollback by sending a message that exceeds the AccountService.debit() limit (withdrawal limit) of 100. For example, create the file giro2.xml and add the following message contents to it: 
    <transaction>
  <transfer>
    <sender>Major Clanger</sender>
    <receiver>Tiny Clanger</receiver>
    <amount>150</amount>
  </transfer>
</transaction>
    Copy to Clipboard Toggle word wrap
    When you copy this file into the PathNameToMsgDir directory, the message never propagates through to the statusLog queue, because the transaction gets rolled back.
Back to top
Red Hat logoGithubredditYoutubeTwitter

Learn

Try, buy, & sell

Communities

About Red Hat Documentation

We help Red Hat users innovate and achieve their goals with our products and services with content they can trust. Explore our recent updates.

Making open source more inclusive

Red Hat is committed to replacing problematic language in our code, documentation, and web properties. For more details, see the Red Hat Blog.

About Red Hat

We deliver hardened solutions that make it easier for enterprises to work across platforms and environments, from the core datacenter to the network edge.

Theme

© 2025 Red Hat