Installing Stored Procedures for JTA
To use JDBC distributed transactions through JTA, the system administrator should use the following procedure to install SQL Server JDBC XA procedures. This must be repeated for each SQL Server installation that will be involved in a distributed transaction.
- Copy the file sqljdbc.dll from the SQL Server 2000 Driver for JDBC installation directory to the SQL_Server_Root/binn directory of the database server for SQL Server.
- From the server, use the ISQL utility to run the instjdbc.sql script. The system administrator should back up the master database before running instjdbc.sql.
At a command prompt, use the following syntax to run instjdbc.sql:
ISQL -Usa -Psa_password -Sserver_name -ilocation\instjdbc.sqlsa_password is the password of the system administrator.
server_name is the name of the server on which SQL Server resides.
location is the full path to instjdbc.sql. This script is located in the SQL Server 2000 Driver for JDBC installation directory.
- The instjdbc.sql script generates many messages. In general, these messages can be ignored; however, you 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 not enough space available in master database to store the JDBC XA procedures or to log changes to existing procedures.
![]() |
Previous Page |
![]() |
Next Page |
![]() |
Synchronize with Contents |