...
- Log into the management console of WSO2 DSS and click Create in the Data Service menu.
- Add a name for the data service and go to the next step.
- Select the Enable Boxcarring check box.
- Click Next to go to the Datasources screen.
- Create a datasource connection for the CompanyDetails database follows:
- Enter XAoffices as the datasource ID.
- Select RDBMS as the datasource type.
- Select External Datasource from the adjoining field.
- Select MySQL as the database engine.
- Enter the following database class corresponding to MySQL:
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
- Click Add Properties and create the connection settings for the OfficeDetails database.:
- url: jdbc:mysql://localhost:3306/OfficeDetails
- user: root
- Save the XAoffices datasource.
- Create a datasource connection for the EmployeeDetails database as follows:
- Enter XAemployees as the datasource ID.
- Select RDBMS as the datasource type.
- Select External Datasource from the adjoining field.
- Select MySQL as the database engine.
- Enter the following database class corresponding to MySQL:
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
- Click Add Properties and create the connection settings for the OfficeDetails database.:
- url: jdbc:mysql://localhost:3306/EmployeeDetails
- user: root
- Save the XAemployees datasource.
...