Page Comparison

...

1. Log into the management console of WSO2 DSS and click Create in the Data Service menu.
2. Add a name for the data service and go to the next step.
3. Select the Enable Boxcarring check box.
4. Click Next to go to the Datasources screen.
5. Create a datasource connection for the CompanyDetails database follows:
   1. Enter XAoffices as the datasource ID.
   2. Select RDBMS as the datasource type.
   3. Select External Datasource from the adjoining field.
   4. Select MySQL as the database engine.
   5. Enter the following database class corresponding to MySQL: com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
   6. Click

      Click Add Properties

      and create

       and specify the following connection settings for

      the

      the OfficeDetails

      database

       database:

      PropertyName	Value
      url	jdbc:

       jdbc:

      mysql://localhost:3306/OfficeDetails

      user

      : root
   Image Removed

   1. root

      The New Datasource screen will now look as follows:

   Image Added
   
6. Save the XAoffices datasource.
7. Create a datasource connection for the EmployeeDetails database as follows:
   1. Enter XAemployees as the datasource ID.
   2. Select RDBMS as the datasource type.
   3. Select External Datasource from the adjoining field.
   4. Select MySQL as the database engine.
   5. Enter the following database class corresponding to MySQL: com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
      Click 
   6. Click Add Properties and create specify the following connection settings for the OfficeDetailsEmployeeDetails database:
      

      Property Name	Value
      url	jdbc:

       jdbc:

      mysql://localhost:3306/EmployeeDetails

      user

      : root
   Image Removed

   1. root

      The New Datasource screen will now look as follows:
   Image Added
8. Save the XAemployees datasource.

...