| Kamil Sykora [MSFT] 2005-05-24, 11:23 am |
| Hello Chinn,
That is correct. You must use cursor mode with XA transactions. The reason
is that direct mode can create cloned connections. From the documentation:
SelectMethod - Direct ... In this mode, each statement requires its own
connection to the database. This is accomplished by "cloning" connections.
Cloned connections use the same connection properties as the original
connection; however, because transactions must occur on a single
connection, auto commit mode is required. Due to this, JTA is not supported
in direct mode.
Thanks,
Kamil
Kamil Sykora
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/secur_ity.
--------------------
| From: "=?Utf-8?B?Y2hpbm4=?=" <chinn@discussions.microsoft.com>
| Subject: Select Mode=Direct
| Date: Tue, 26 Apr 2005 08:50:02 -0700
| Lines: 6
|
| Is this correct..
|
| Microsoft JDBC driver doesn't support 'DIRECT' select mode for
XADatasources
| (XA database connections). So we have to use cursor method.
| When I tried to switch to Direct, App didn't start with the error that
| 'direct' select method can not be used for XA Connections.
|
|