JTA/JDBC coordination using IBM MQ classes for Java

JTA/JDBC coordination using IBM MQ classes for Java

IBM MQ classes for Java supports the MQQueueManager.begin() method, which allows IBM MQ to act as a coordinator for a database which provides a JDBC type 2 or JDBC type 4 compliant driver.

This support is not available on all platforms. To check which platforms support JDBC coordination, see System Requirements for IBM MQ.

To use the XA-JTA support, you must use the special JTA switch library. The method for using this library varies depending on whether you are using Windows or one of the other platforms.

Configure JTA/JDBC coordination on Windows
The XA library is supplied as a DLL with a name of the format jdbcxxx.dll.
Configure JTA/JDBC coordination on platforms other than Windows
Object files are supplied. Link the appropriate one using the supplied makefile, and declare it to the queue manager using the configuration file.
Use JTA/JDBC coordination
Code your API calls as in the supplied example.
Known problems and limitations with JTA/JDBC coordination
Some of the problems and limitations of JTA/JDBC support depend on the database management system in use, for example, tested JDBC drivers behave differently when the database is shut down while an application is running. If the connection to the database that an application is using is broken, there are steps that the application can perform to reestablish a new connection to the queue manager and the database so that it can then use those new connections to perform the transactional work required.
Parent topic: Writing IBM MQ classes for Java applications