This documentation is for WSO2 Data Services Server 3.2.0. View the home page of the latest release.

Unknown macro: {next_previous_link3}
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

RDBMS datasources allow you to create a data service using a relational database as the data storage type.

You can get the Add New Datasource screen shown below on the management console by executing steps 1 to 3 in creating a data service. Then, select RDBMS as the Datasource Type. It opens the RDBMS-specific options as shown below: 

 

The options in the above window are described below:

datasource type

There are two types of RDBMS datasources as follows:

  • Default
    For the default type, connection properties such as driver class, URL and credentials must be entered as shown in the example above.

  • External datasource
    If you need to add a datasource supported by an external provider class such as com.mysql.jdbc.jdbc2.optional.MysqlXADataSource, select 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.

Database engine

The database management system. In the above example, we take MySQL.

Driver class/URL

Depending on the database engine, copy the relevant JDBC driver to:

  • <PRODUCT_HOME>/repository/components/lib directory

For example, cp mysql-connector-java-5.XX-bin.jar /home/user/wso2ds/wso2-dataservices-XX/repository/components/lib.

NOTE: If the driver class does not exist in the relevant folders when you create the datasource, you get an exception. For example, 'Cannot load JDBC driver class com.mysql.jdbc.Driver'.

Use as secret alias

For information, see Securing Passwords.

datasource configuration parameters

For information, see Datasource Configuration Parameters.

Dynamic user authentication

For information, see Dynamic User Authentication.

To write a query to this datasource, see Writing Data Service Queries.

  • No labels