XA Connection Properties in Data Federation

These examples show typical XA connection properties used to support distributed transactions in Sybase Data Federation.

Note: Different XA drivers allow—or require—different connection properties. For details on configuring your XA-compliant JDBC driver, including the particular XA connection properties to use, refer to the documentation for the driver.

Database	Connection Properties
Sybase ASE	ServerName=<database-host-name> PortNumber=<database-port> (e.g. 5000) ResourceManagerType=2 ResourceManagerName=connection DatabaseName=<database-name> NetworkProtocol=Tds User=<db-user-name> Password=<db-user’s-password>
Oracle 10g	URL=jdbc:oracle:thin:@<db-host-name>:<db-port>:<db-name> User=<db-user-name> Password=<db-user’s-password>
MySQL	URL=jdbc:mysql://<db-host-name>[:<db-port>]/<db-name> User=<db-user-name> Password=<db-user’s-password>

Database

Connection Properties

Sybase ASE

ServerName=<database-host-name>

PortNumber=<database-port> (e.g. 5000)

ResourceManagerType=2

ResourceManagerName=connection

DatabaseName=<database-name>

NetworkProtocol=Tds

User=<db-user-name>

Password=<db-user’s-password>

Oracle 10g

URL=jdbc:oracle:thin:@<db-host-name>:<db-port>:<db-name>

User=<db-user-name>

Password=<db-user’s-password>

MySQL

URL=jdbc:mysql://<db-host-name>[:<db-port>]/<db-name>

User=<db-user-name>

Password=<db-user’s-password>

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.