M2M AD301 Uživatelská příručka stáhnout pdf (Strana 49)

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.

1 2 ... 44 45 46 47 48 49 50 51 52 53 54 ... 229 230

Žádné komentáře

M2M AD301 Uživatelská příručka Strana 49