This documentation is for WSO2 Private PaaS 4.1.0. View documentation for the latest release.
Page Comparison - Configuring an RDBMS Datasource (v.2 vs v.3) - WSO2 Private PaaS 4.1.0 - WSO2 Documentation

Versions Compared

Key

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

Follow the steps given below to create RDBMS datasources for your product server. RDBMS datasources allow you to service enable data from relational databases.

  1. Log in to the management console of your product and click Data Sources on the Configure tab. The datasources that are already created will be listed.
  2. Click Add Data Source to open the following screen:
  3. Select 'RDBMS' for the Data Source Type field to define an RDBMS configuration.
  4. Enter values for the remaining fields as explained below.
    • Name : Name of the datasource (must be a unique value).
    • Data Source Provider : Specify the  datasource provider.
    • Driver : The class name of the JDBC driver to use. 
    • URL : The connection URL to pass to the JDBC driver to establish the connection
    • User Name : The connection user name to pass to the JDBC driver to establish the connection
    • Password : The connection password to pass to the JDBC driver to establish the connection
    • Expose as a JNDI Data Souce : Allows you to specify the  JNDI data source .
    • Data Source Configuration Parameters : Allows you to specify the  datasource connection pool parameters  when creating an RDBMS datasource
  5. Be sure to copy the JDBC driver relevant to the database engine to the <PRODUCT_HOME>/repository/components/dropins and <PRODUCT_HOME>/repository/components/lib directories. For example, if you are using MySQL, you would specify com.mysql.jdbc.Driver as the driver and would copy mysql-connector-java-5.XX-bin.jar to these directories. If you do not copy the driver to these directories when you create the datasource, you will get an exception similar to "Cannot load JDBC driver class com.mysql.jdbc.Driver".
  6. After creating datasources, they appear on the Data Sources page. If required, you can  edit or delete them  by clicking  Edit  or  Delete .
Note

This is the default RDBMS datasource configuration provided by WSO2. You can also write your own RDBMS configuration by selecting the custom datasource option.