User guide

Data Integration with Sybase Avaki Studio 37
Creating database connectors
for the database vendor’s JDBC driver. (For purposes of the tutorial, leave this field
blank.)
These XA drivers have been tested with Avaki:
— For Sybase ASE: com.sybase.jdbc3.jdbc.SybXADataSource
(ASE 15.0 with jConnect 6.05)
— For Oracle 10g: oracle.jdbc.xa.client.OracleXADataSource
(Oracle 10g release 10.1.0.2.0 with JDBC driver version 10.2.0.1.0)
— For MySQL: com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
(MySQL 5.0 with MySQL Connector/J 5.0)
• XA connection properties (optional): Some XA connection properties might be
required by your XA driver. (For purposes of the tutorial, leave this field blank.)
Here are some that are typically specified:
— For 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>
— For Oracle 10g:
URL=jdbc:oracle:thin:@<db-host-name>:<db-port>:<db-name>
User=<db-user-name>
Password=<db-user’s-password>
— For MySQL:
URL=jdbc:mysql://<db-host-name>[:<db-port>]/<db-name>
User=<db-user-name>
Password=<db-user’s-password>
Note For details on configuring your XA-compliant JDBC driver, including the
particular XA connection properties to use, refer to the documentation for the
driver.