SQL Server JDBC - XA Support?

Author

XA Support?

jef

2005-10-12, 11:23 am

I am using the new 2005 beta 2 drivers, and I am trying to enlist sql server
in a distributed transaction with a JMS resource (activemq). I was assuming
that I needed XA support, but I was a little confused in reading the
xa_install.txt about the MS DTC requirement. If I am using geronimo's
transaction manager, do I need MS DTC? Can I do 2PC-style transactions
between sql server and jms without xa? I was assuming I needed it. If so,
does that basically make the DTC the resource manager for sql server?

Thanks in advance,
--
jef - integralpath.blogs.com

Matt Neerincx [MSFT]

2005-10-12, 11:23 am

In order to process XA transactions, we leverage the MSDTC service on the
SQL Server side (as well as a dll that is loaded inside SQL Server
sqljdbc_xa.dll).

So yes, you will need to go to the SQL Server machine and setup
sqljdbc_xa.dll, and enable XA transactions in MSDTC on the SQL Server
machine. I was planning on writing up a short "step-by-step" document on
this and posting to my blog, but here is the abbreviated version of how to
get XA transactions working with our SQL JDBC 2005 driver:

1. Goto SQL machine, copy sqljdbc_xa.dll to C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Binn folder (the same folder where sqlservr.exe resides
for your SQL Server instance).
2. Register the dll using the xa_install.sql script (you will need to be
admin on SQL Server to do this).
3. On the SQL Server machine, goto Control Panel | Administrative Tools |
Component Services tool.
Drill down and locate "My Computer" node and right click to get
properties.
4. Goto MSDTC tab on properties, click "Security Configuration" button,
check "Enab;le XA Transactions", click OK.'

Step 4 should restart MSDTC automatically. Note you do not need to enable
anything else here for MSDTC, this is the bare minimum.

5. Stop and restart SQL Server instance so it will pick up new MSDTC
settings.

This should get it working.

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"jef" <jef@discussions.microsoft.com> wrote in message
news:1C5FC4AF-1E08-48D2-99CA- 27B914E47DA9@microso
ft.com...
>I am using the new 2005 beta 2 drivers, and I am trying to enlist sql
>server
> in a distributed transaction with a JMS resource (activemq). I was
> assuming
> that I needed XA support, but I was a little confused in reading the
> xa_install.txt about the MS DTC requirement. If I am using geronimo's
> transaction manager, do I need MS DTC? Can I do 2PC-style transactions
> between sql server and jms without xa? I was assuming I needed it. If so,
> does that basically make the DTC the resource manager for sql server?
>
> Thanks in advance,
> --
> jef - integralpath.blogs.com

jef

2005-10-17, 1:24 pm

thanks, Matt.
--
jef - integralpath.blogs.com

"Matt Neerincx [MSFT]" wrote:

> In order to process XA transactions, we leverage the MSDTC service on the
> SQL Server side (as well as a dll that is loaded inside SQL Server
> sqljdbc_xa.dll).
>
> So yes, you will need to go to the SQL Server machine and setup
> sqljdbc_xa.dll, and enable XA transactions in MSDTC on the SQL Server
> machine. I was planning on writing up a short "step-by-step" document on
> this and posting to my blog, but here is the abbreviated version of how to
> get XA transactions working with our SQL JDBC 2005 driver:
>
> 1. Goto SQL machine, copy sqljdbc_xa.dll to C:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\Binn folder (the same folder where sqlservr.exe resides
> for your SQL Server instance).
> 2. Register the dll using the xa_install.sql script (you will need to be
> admin on SQL Server to do this).
> 3. On the SQL Server machine, goto Control Panel | Administrative Tools |
> Component Services tool.
> Drill down and locate "My Computer" node and right click to get
> properties.
> 4. Goto MSDTC tab on properties, click "Security Configuration" button,
> check "Enab;le XA Transactions", click OK.'
>
> Step 4 should restart MSDTC automatically. Note you do not need to enable
> anything else here for MSDTC, this is the bare minimum.
>
> 5. Stop and restart SQL Server instance so it will pick up new MSDTC
> settings.
>
> This should get it working.
>
> --
> Matt Neerincx [MSFT]
>
> This posting is provided "AS IS", with no warranties, and confers no rights.
>
> Please do not send email directly to this alias. This alias is for newsgroup
> purposes only.
>
> "jef" <jef@discussions.microsoft.com> wrote in message
> news:1C5FC4AF-1E08-48D2-99CA- 27B914E47DA9@microso
ft.com...
>
>
>

Sponsored Links