SQL Server JDBC - XA transactions

Author

XA transactions

Meenal Dhody

2005-12-06, 9:23 am

I used the following set of instructions to enable XA transactions on our
SQL box:

For Window 2000:
-----------------------
Copy sqljdbc.dll file from
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\SQLServer
JTA\ to your SQL Server's "binn" directory (most likely C:\Program
Files\Microsoft SQL Server\MSSQL\Binn). Then open your instjdbc.sql
script from C:\Program Files\Microsoft SQL Server 2000 Driver for
JDBC\SQLServer JTA\ within Query Analyzer and run the script. This will
install the extended stored procedures into SQL Server so that it can
reference the sqljdbc.dll file.

For Window Server 2003:
-----------------------
1. Connect JDBC Drivers (DataDirect Connect JDBC, IBM(r) WebSphere(r)
embedded Connect JDBC) have the XA DLL sqljdbc.dll that is normally
installed on SQLServer_Install_Ro
ot\MSSQL\Binn.
For example: c:\Program Files\Microsoft SQL Server\MSSQL\Binn) The
registry values required for XA transactions are not created
automatically. You must create the values manually as follows:

2. Turn on support for XA transactions:
a ) Open Component Services.
b) Expand the tree view to locate the computer where you want to
turn on support for XA transactions; for example, My Computer.
Right-click the computer name, then click Properties.
c) Click the MSDTC tab, then click Security Configuration.
d) Under Security Settings, click the check box for XA Transactions
to turn on this support.
Click OK, then click OK again.

3. Create a registry named-value:
Use Registry Editor and navigate to registry key:
HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\MS
DTC\XADLL
Create a new registry named-value:
Name is the file name of the XA DLL (in the format dllname.dll) Type is
String (REG_SZ) Value is the full path name (including the file name) of
the DLL file Name Type Value sqljdbc.dll String (REG_SZ) c:\Program
Files\Microsoft SQL Server\MSSQL\Binn\sq
ljdbc.dll

Note: You must create an entry for each XA DLL file that you plan to
use. Also, if you are configuring MS DTC on a cluster, you must create
these registry entries on each node in the cluster.

Since out box is windows 2003 I only followed those steps and did not run
instjdbc.sql. The users are getting the following error:
Original exception: com.ibm.ws.exception.WsException: DSRA8100E:
Unable to get a XAConnection from the DataSource

Do I need to run that script as well. Is there something else I need to do
to make this work?

thanks
Meenal

Kamil Sykora [MSFT]

2005-12-06, 8:23 pm

Hello Meenal,

Which driver and version are you using and where did you locate these
instructions?

The 2000 version of the driver documentation states that you have to
install the extended stored procedures by running the instjdbc.sql script
regardless of what OS you are using.
The 2005 (Beta2) version of the driver readme states that you need to run
the xa_install.sql script.

Thanks,
Kamil

Kamil Sykora [MSFT]
Microsoft Developer Support - Webdata

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.
--------------------
| From: "Meenal Dhody" < meenal_dhody@hotmail
.com>
| Subject: XA transactions
| Date: Tue, 6 Dec 2005 09:01:34 -0500
|
| I used the following set of instructions to enable XA transactions on our
| SQL box:
|
| For Window 2000:
| -----------------------
| Copy sqljdbc.dll file from
| C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\SQLServer
| JTA\ to your SQL Server's "binn" directory (most likely C:\Program
| Files\Microsoft SQL Server\MSSQL\Binn). Then open your instjdbc.sql
| script from C:\Program Files\Microsoft SQL Server 2000 Driver for
| JDBC\SQLServer JTA\ within Query Analyzer and run the script. This will
| install the extended stored procedures into SQL Server so that it can
| reference the sqljdbc.dll file.
|
| For Window Server 2003:
| -----------------------
| 1. Connect JDBC Drivers (DataDirect Connect JDBC, IBM(r) WebSphere(r)
| embedded Connect JDBC) have the XA DLL sqljdbc.dll that is normally
| installed on SQLServer_Install_Ro
ot\MSSQL\Binn.
| For example: c:\Program Files\Microsoft SQL Server\MSSQL\Binn) The
| registry values required for XA transactions are not created
| automatically. You must create the values manually as follows:
|
| 2. Turn on support for XA transactions:
| a ) Open Component Services.
| b) Expand the tree view to locate the computer where you want to
| turn on support for XA transactions; for example, My Computer.
| Right-click the computer name, then click Properties.
| c) Click the MSDTC tab, then click Security Configuration.
| d) Under Security Settings, click the check box for XA Transactions
| to turn on this support.
| Click OK, then click OK again.
|
| 3. Create a registry named-value:
| Use Registry Editor and navigate to registry key:
| HKEY_LOCAL_MACHINE\S
OFTWARE\Microsoft\MS
DTC\XADLL
| Create a new registry named-value:
| Name is the file name of the XA DLL (in the format dllname.dll) Type is
| String (REG_SZ) Value is the full path name (including the file name) of
| the DLL file Name Type Value sqljdbc.dll String (REG_SZ) c:\Program
| Files\Microsoft SQL Server\MSSQL\Binn\sq
ljdbc.dll
|
| Note: You must create an entry for each XA DLL file that you plan to
| use. Also, if you are configuring MS DTC on a cluster, you must create
| these registry entries on each node in the cluster.
|
| Since out box is windows 2003 I only followed those steps and did not run
| instjdbc.sql. The users are getting the following error:
| Original exception: com.ibm.ws.exception.WsException: DSRA8100E:
| Unable to get a XAConnection from the DataSource
|
| Do I need to run that script as well. Is there something else I need to
do
| to make this work?
|
| thanks
| Meenal
|
|
|

Sponsored Links