Two connections to Microsoft SQL Server when making XAConnection using DataDirect Connect JDBC Driver
 Technote (troubleshooting)
 
Problem(Abstract)
Why do we see two connections to SQL Server database when using XA data source in WebSphere® Application Server? There is only one connection for non-XA data source.
 
Cause
It is not a defect. It is by design.
 
Resolving the problem
For an XA connection, the WebSphere Embedded Connect JDBC Driver (or DataDirect Connect JDBC Driver) creates a connection that the normal database access occurs on. It also creates another connection that it uses to communicate with DTC (Microsoft® Distributed Transaction Coordinator) to manage the XA operations.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): z/OS
Software version: 6.1
Software edition:
Reference #: 1253973
IBM Group: Software Group
Modified date: Jan 22, 2007