Configuring WebSphere Application Server for Derby manually

IBM Worklight V5.0.5. automatically configures your databases. However, if you are using an older version of IBM Worklight, or if you are experiencing problems with the automatic configuration process for the WebSphere Application Server, you must manually set up and configure your Apache Derby database and then the WebSphere Application Server for Derby. Complete the Apache Derby database setup procedure before continuing. WebSphere Application Server, versions 7 and 8, include a Derby .jar file in the $WAS_HOME/derby/lib directory.

  1. Set up the JDBC provider.

    1. In the WebSphere Application Server console, click Resources > JDBC > JDBC Providers and select the Derby JDBC Provider.

    2. Set Name to Derby JDBC Provider.

    3. Set Implementation class name to org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource.

  2. Set up the data source for the IBM Worklight database.

    1. In the WebSphere Application Server console, click Resources > JDBC > Data sources and select the Derby JDBC Driver datasource.

    2. Set JNDI name to jdbc/WorklightDS.

    3. In the “Common and required data source properties” pane, set Database name to WRKLGHT.

    4. Click Resources > JDBC > Data sources > Driver DataSource > Custom properties.

    5. Set user = worklight.

    6. Set password = worklight.

  3. Set up the data source for the IBM Worklight report database.

    1. In the WebSphere Application Server console, click Resources > JDBC > Data sources and select the Derby JDBC Driver datasource. – Set JNDI name to – – Click Resources > JDBC > Data sources > Driver DataSource > Custom properties – –

    2. Set JNDI name to jdbc/WorklightReportsDS.

    3. In the “Common and required data source properties” pane, set Database name to WLREPORT.

    4. Click Resources > JDBC > Data sources > Driver DataSource > Custom properties.

    5. Set user = worklight.

    6. Set password = worklight.


Parent topic Troubleshooting