关于tuxedo Xa自动重连数据库有哪几种方式? (Doc ID 2065097.1)

Last updated on MAY 17, 2017

Applies to:

Oracle Tuxedo - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Goal

目前客户生产环境tuxedo发现当数据库重启后,交易类业务能自动重连数据库,查询类业务不能自动重连。两类业务的区别如下:
交易类业务:tuxedo客户端 tpbegin tpcall tpcommit. tpcall服务端对数据库进行dml操作
查询类业务:tuxedo客户端 tpcall tpcall服务端对数据库进行select操作
换言之就是 交易类业务在tpbegin下进行的 查询类业务是直接调用服务端,服务端直接exec sql select.....,服务端代码里在srvinit方法中有tpopen,其它地方没有重连逻辑。
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms