Due to a known issue do not use JDK1.8.0_151 with WSO2 products. Use JDK 1.8.0_144 until JDK 1.8.0_162-ea is released.
This documentation is for WSO2 Data Services Server version 3.5.1. For the latest documentation, see the documentation for WSO2 Enterprise Integrator.
Data Services Server 3.5.1
Expand all   Collapse all

Versions Compared

Old Version 22

changes.mady.by.user Nilmini Perera

Saved on

compared with

New Version Current

changes.mady.by.user Praneesha Chandrasiri

Saved on

Key

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

...

  1. Log in to the management console and select Create under Data Service.

  2. In the Create Data Service screen, enter AccountDetailsService as the data service name.


  3. Click Next. When you get to the Add New Data Source screen, select RDBMS as the data source type. The RDBMS-specific options will be available for editing.

  4. In the Datasource ID field, enter AccountDetails as the datasource name.

  5. In the Datasource Type field, select RDBMS and Default from the lists.

    Info

    If you enter External instead of the Default datasource type, your datasource should be supported by an external provider class, such as com.mysql.jdbc.jdbc2.optional.MysqlXADataSource. You can select s the the External option and enter the name and value of connection properties by clicking Add Property. For example,

    After an external datasource is created, it can be used as a usual datasource in queries. See the tutorial on handling distributed transactions for more information on using external datasources.

  6. Enter MySQL in the Database Engine field.

  7. Enter the following driver class for MySQL in the Driver Class URL field: com.mysql.jdbc.Driver.

    Warning

    Be sure to download the JDBC driver for MySQL from here and copy it to your <DSS_HOME>/repository/components/lib directory.

    If the driver class does not exist in the relevant folders when you create the datasource, you will get an exception such as 'Cannot load JDBC driver class com.mysql.jdbc.Driver'.

    Info

    See the section on working with RDBMS datasources, for more options that you can use with your RDBMS data service.

  8. Enter the URL to your MySQL database in the URL field:  jdbc:mysql://localhost:3306/trainingdb

  9. Enter the username and password to connect to your MySQL database. By default the username is root and the password is blank. 

  10. Click Next to start defining a query.

...