Re: XA Support?

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:1C5FC4AF-1E08-48D2-99CA-27B914E47DA9@xxxxxxxxxxxxxxxx
> >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
>
>
>
.

Loading