|
| Problem | When using JDBC™ distributed transaction through Java™ Transaction API (JTA) with WebSphere® embedded Connect JDBC driver to access a Microsoft® SQL Server database, a set of stored procedures must be installed on the Microsoft SQL Server installation.
This technote explains the procedure to install the required Microsoft SQL Server JDBC XA procedures. | | | | Solution | - Download the ConnectJDBC33-JTA.zip for WebSphere embedded connect JDBC 3.3. driver from DataDirect Connect JDBC and SequeLink JDBC Drivers.
- Unzip the file ConnectJDBC33-JTA.zip into a temporary directory, such as temp_dir.
- Copy the sqljdbc.dll file, either the 32-bit or 64-bit version, to the Microsoft SQL Server database server:
- On a 32-bit platform, copy the sqljdbc.dll file from the temp_dir/SQLServer JTA/32Bit directory to the SQL_Server_Root/binn directory of the Microsoft SQL Server database server.
- On a 64-bit platform, copy the sqljdbc.dll from the temp_dir/SQLServer JTA/64Bit directory to the SQL_Server_Root/binn directory of the Microsoft SQL Server database server where:
SQL_Server_Root is your Microsoft SQL Server installation directory.
From the database server, use the ISQL utility to run the instjdbc.sql script. As a precaution, the system administrator should back up the master database before running instjdbc.sql.
At a command prompt, run instjdbc.sql using the following syntax:
ISQL -Usa -Psa_password-Sserver_name-ilocation\instjdbc.sql
where: sa_password is the password of the system administrator. server_name is the name of the server on which the Microsoft SQL Server database resides. location is the full path to instjdbc.sql. This script is located in the temp_dir/SQLServer JTA directory.
The instjdbc.sql script generates many messages. In general, these messages can be ignored; however, the system administrator should scan the output for any messages that indicate an execution error.
The last message should indicate that instjdbc.sql ran successfully. The script fails when there is insufficient space available in the master database to store the JDBC XA procedures or to log changes to existing procedures.
For more information, refer to DataDirect Connect for JDBC User's Guide and Referencewhich is available at DataDirect's JDBC Product Documentation. | |
| | |
| |
|
Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, DB Connections/Connection Pooling Operating system(s): Windows, Windows 2000, Windows NT, Windows Server 2003, Windows XP Software version: 3.5, 4.0, 5.0, 5.1, 6.0 Software edition: Edition Independent Reference #: 1191902 IBM Group: Software Group Modified date: 2004-12-01
(C) Copyright IBM Corporation 2000, 2004. All Rights Reserved.
|