Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1272202
  • 博文数量: 185
  • 博客积分: 50
  • 博客等级: 民兵
  • 技术积分: 3934
  • 用 户 组: 普通用户
  • 注册时间: 2007-09-11 13:11
个人简介

iihero@ChinaUnix, ehero.[iihero] 数据库技术的痴迷爱好者. 您可以通过iihero AT qq.com联系到我 以下是我的三本图书: Sybase ASE in Action, Oracle Spatial及OCI高级编程, Java2网络协议内幕

文章分类

全部博文(185)

文章存档

2014年(4)

2013年(181)

分类: Sybase

2013-07-17 14:32:19

ASE支持分布式事务处理,需要一些额外配置。
Using XA resources with Adaptive Server Enterprise
To use XA resources with an Adaptive Server Enterprise 12.0 or later database running on UNIX or Windows, perform these tasks:

(Windows only.) Verify that you have the correct license file, which is located in %SYBASE%/SYSAM-1_0/licenses/license.dat. To run XA transactions, you must have the ASE_DTM license.

Configure the database to use XA transactions. For more information, see Using the Adaptive Server Distributed Transaction Management Features, available on the Sybase Product Manuals Web page.
Create a database to use for XA transactions.
 
Configure the database tables and stored procedures required for JDBC connection caches, which are available in $JAGUAR/html/classes/sp/sql_server12.sql.
Configure the database tables required for C/C++ connection caches. You can install these tables by running xa_load.sh (UNIX) or xa_load.bat (Windows), which is located in the EAServer html/classes/sp directory.

Create a login, other than sa, for connecting to the database. You cannot use the sa login to connect to an Adaptive Server Enterprise databases for XA transactions.
Modifying the Adaptive Server configuration files
When you configure an XA resource for C/C++ connection caches, you need to modify two configuration files.
On UNIX:
$JAGUAR/interfaces
$JAGUAR/xa_config
On Windows:
%JAGUAR%/ini/sql.ini
%JAGUAR%/ini/xa_config
interfaces and sql.ini
On UNIX, add these lines to the interfaces file:
DbServer
   master tcp ether host 5300
   query tcp ether host 5300
On Windows, add these lines to the sql.ini file:
[DbServer]
master=NLWNSCK,host,5200
query=NLWNSCK,host,5200

where DbServer is the name of the database server and host is the name of the machine on which the database server runs. DbServer should have the same value that you entered in the Server Name field when you configured the XA resource.

xa_config
For both operating systems, add these lines to the xa_config file:
[xa]
   lrm=serverName
   server=DbServer
where:
serverName is the name you entered in the Server Name field when you configured the XA resource.
DbServer is the name of the server you entered in either the interfaces file or the sql.ini file.
serverName and DbServer represent the same server and should have the same value.
阅读(1727) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~