Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Log into the management console of WSO2 EI and click Create under Data Service.
  2. Add a name for the data service and go to the next step.
  3. Select the Enable Boxcarring and Disable Legacy Boxcarring Mode check boxes.

    Note

    The Enable boxcarring option enables both the legacy boxcarring and the new request box methods. You can disable the legacy boxcarring method and use the request box method by selecting the Disable Legacy Boxcarring Mode option.

  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 Add Properties and create the connection settings for the OfficeDetails database.
      URL: jdbc:mysql://localhost:3306/OfficeDetails
      USER: root
  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
    6. Click Add Properties and create the connection settings for the OfficeDetails database.
      URL: jdbc:mysql://localhost:3306/EmployeeDetails
      USER: root
  8. Save the XAemployees datasource.

...