OceanBase logo

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Resources

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS

OceanBase Cloud

OceanBase Database

Tools

Connectors and Middleware

QUICK START

OceanBase Cloud

OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Company

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview
DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All
BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All
PRODUCTS
OceanBase CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase Database
BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

Embedded SQL in C for OceanBase

V1.1.7Enterprise Edition

  • What's New
  • What is ECOB?
  • ECOB compatibility with Pro*C
  • Install ECOB
  • Data types and variables
    • Overview
    • Supported data types
    • Data type conversion
    • Indicator variable
    • VARCHAR variable
    • Structure
    • String pointer
  • Embedded SQL statements
    • Overview
    • Variable declaration
    • Connect to OceanBase databases
    • Basic SQL statements
    • Prepared statements
    • Stored procedures
    • Cursor
    • Simple dynamic SQL statement
    • ANSI dynamic SQL statements
    • Error handling
      • SQLCA structure
      • WHENEVER statement
    • LOB-related SQL statements
  • Use ECOB
    • Environment preparation
    • Use ECOB
    • Compile the Tuxedo service
  • Command Line Options

Download PDF

What's New What is ECOB? ECOB compatibility with Pro*C Install ECOB Overview Supported data types Data type conversion Indicator variable VARCHAR variable Structure String pointer Overview Variable declaration Connect to OceanBase databases Basic SQL statements Prepared statements Stored procedures Cursor Simple dynamic SQL statement ANSI dynamic SQL statements SQLCA structure WHENEVER statement LOB-related SQL statements Environment preparation Use ECOB Compile the Tuxedo service Command Line Options
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogLive DemosTraining & Certification
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. Embedded SQL in C for OceanBase
  3. V1.1.7
iconEmbedded SQL in C for OceanBase
V 1.1.7Enterprise Edition

Compile the Tuxedo service

Last Updated:2023-06-29 11:12:55  Updated
share
What is on this page
Process XA transactions
Configure Tuxedo to use OceanBase XA
Configure the resource manager
Build the transaction manager service
Configure UBBCONFIG GROUPS
Compile the application service

folded

share

#docslug#/ecob/ecob/V1.1.6/bygbea

Process XA transactions

OceanBase implements the eXtended Architecture (XA) distributed transaction interface, which can be used in the X/Open distributed transaction processing (DTP) environment. Based on the XA interface, a distributed transaction manager, for example, Oracle Tuxedo, can use OceanBase Database as a resource manager. In XA transactions, the transaction manager uses the two-phase commit protocol to commit global transactions.

Developers who use the Tuxedo service usually write the business code in C language that contains the embedded SQL statements. ECOB enables you to precompile .pc files and then compile and link the files to the Tuxedo service.

Configure Tuxedo to use OceanBase XA

This section describes how to set OceanBase as a resource manager in Tuxedo. For more information about Tuxedo, see the official documentation of Tuxedo.

Configure the resource manager

Open the $TUXDIR/udataobj/RM configuration file, and add a row of OceanBase XA resource manager named OB_XA.

OB_XA:xaosw:-L/u01/obclient/lib -L/usr/local/lib64 -lobci -lobclnt -lecob

Build the transaction manager service

Run the buildtms command of Tuxedo to build a transaction manager service (TMS) for OceanBase XA resource manager.

buildtms -o TMS_OB -r OB_XA -v
cp TMS_OB $TUXDIR/bin

Configure UBBCONFIG GROUPS

In the UBBCONFIG configuration file of the Tuxedo runtime, add the following OPENINFO in all services and groups that use OceanBase Database.

OPENINFO="OB_XA:OB_XA+Acc=P/MyUser@MyTenant/MyPassword+SqlNet=MyTnsName+SesTm=60+DbgFl=15+LogDir=."

Compile the application service

Run the buildserver command of Tuxedo to compile your Application-to-Transaction Monitor Interface (ATMI) service application. In the buildserver command, the -r parameter specifies the resource manager name in the RM file.

buildserver -r OB_XA

Previous topic

Use ECOB
Last

Next topic

Command Line Options
Next
What is on this page
Process XA transactions
Configure Tuxedo to use OceanBase XA
Configure the resource manager
Build the transaction manager service
Configure UBBCONFIG GROUPS
Compile the application service