+

Search Tips   |   Advanced Search

Configure WebSphere Application Server for Derby manually

We can set up and configure the Apache Derby database manually with WebSphere Application Server.

Complete the Apache Derby database setup procedure before continuing.

  1. Add the Derby JAR file from MF_HOME/ApplicationCenter/tools/lib/derby.jar to was_install_dir/optionalLibraries/IBM/mfp_server/jdbc_driver/derby.

    If that directory does not exist, create it.

  2. Set up the JDBC provider.

    1. In theWebSphere Application Server console, click Resources > JDBC > JDBC Providers.

    2. Set the scope to Node level.

    3. Click New.

    4. Set Database type to User-defined.

    5. Set Class Implementation name to org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource40.

    6. Set Name to Worklight - Derby JDBC Provider.

    7. Set Description to Derby JDBC provider for Worklight.

    8. Click Next.

    9. Set the Class path to was_install_dir/optionalLibraries/IBM/mfp_server/jdbc_driver/derby/derby.jar.

    10. Click Finish.

  3. Create the data source for the runtime database.

    1. In the WebSphere Application Server console, click Resources > JDBC > Data sources.

    2. Set the scope to Node level.

    3. Click New.

    4. Set Data source Name to Worklight Database.

    5. Set JNDI name to jdbc/WorklightDS.

    6. Click Next.

    7. Select the existing JDBC provider named Worklight - Derby JDBC Provider.

    8. Click Next.

    9. Click Next.

    10. Click Finish.

    11. Click Save.

    12. In the table, click the Worklight Database datasource created.

    13. Under Additional Properties, click Custom properties.

    14. Click databaseName.

    15. Set Value to the path to the WRKLGHT database created by the configuredatabase ant task.

    16. Click OK.

    17. Click Save.

    18. At the top of the page, click Worklight Database.

    19. Under Additional Properties, click WebSphere Application Server data source properties.

    20. Select Non-transactional datasource.

    21. Click OK.

    22. Click Save.

    23. In the table, select the Worklight Database datasource created.

    24. Click test connection (only if you are not on the console of a WAS dmgr).

  4. Set up the data source for the reports database.

    1. In the WebSphere Application Server console, click Resources > JDBC > Data sources.

    2. Set the scope to Node level.

    3. Click New.

    4. Set Data source name to Worklight Reports Database.

    5. Set JNDI name to jdbc/WorklightReportsDS.

    6. Click Next.

    7. Select the existing JDBC provider named Worklight - Derby JDBC Provider.

    8. Click Next.

    9. Click Next.

    10. Click Finish.

    11. Click Save.

    12. In the table, click the Worklight Reports Database datasource created.

    13. Under Additional properties, click Custom properties.

    14. Click databaseName.

    15. Set Value to the path to the WLREPORT database created by the configuredatabase ant task.

    16. Click OK.

    17. Click Save.

    18. At the top of the page, click Worklight Reports Database.

    19. Under Additional Properties, click WebSphere Application Server data source properties.

    20. Select Non-transactional datasource.

    21. Click OK.

    22. Click Save.

    23. In the table, select the Worklight Reports Database datasource created.

    24. Optional: Only if you are not on the console of a WebSphere Application Server Deployment Manager, click test connection.


Parent topic: Configure the Apache Derby databases manually