RE: XA transactions
- From: kamils@xxxxxxxxxxxxxxxxxxxx (Kamil Sykora [MSFT])
- Date: Tue, 06 Dec 2005 22:17:13 GMT
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@xxxxxxxxxxx>
| 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_Root\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\SOFTWARE\Microsoft\MSDTC\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\sqljdbc.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
|
|
|
.
- References:
- XA transactions
- From: Meenal Dhody
- XA transactions
- Prev by Date: RE: Error when comparing against empty string using JDBC 2005 Beta 2
- Next by Date: Re: Null pointer exception with Windows authentication
- Previous by thread: XA transactions
- Next by thread: RE: Error establishing socket
- Index(es):
Relevant Pages
|
