Background and System Requirements

Use the dtm_tm_role to enable the Distribute Transaction Management support.

  • jConnect must be communicating directly with the resource manager within Sybase Adaptive Server version 12.0 and later, and the installation must have Distributed Transaction Management support.
  • Any user who wants to participate in a distributed transaction must be granted dtm_tm_role, or the transactions fail.

  • To use distributed transactions, you must install the stored procedures in the /sp directory. Refer to Installing Stored Procedures in the jConnect for JDBC Installation Guide.

Distributed Transaction Management Support with Version 12.x

The distributed transaction management support with version 12.x contains a client application going into middle tier components using JTA to go into jConnect.Using TDS it goes into ASE 12.x.