Creating the Database for JavaDB (Derby)

If you are using a JavaDB (Derby) database, you only need to start the WLM SE to create the database. The WLM SE installation automatically creates the default JDBC connection pool and data resource for the database (because the create flag is set to true for the connection pool). Starting the service engine automatically creates a Derby database named WORKFLOWDB with a schema named WORKFLOW. The login username and password for this database are both WORKFLOW.

To Start the WLM Service Engine

1. In the NetBeans IDE, click the Services tab.

2. Expand Servers > GlassFish v2.1 > JBI > Service Engines.

3. Right-click sun-wlm-engine, and then select Start.

To Connect to the Database From NetBeans

1. In the NetBeans IDE, click the Services tab.

2. Expand Databases, and then expand Drivers.

3. Right-click Java DB (Network), and then select Connect Using.

   The New Database Connection dialog box appears.

4. Enter the following information:

   • Host: The name of the server on which the database is located. By default, this is localhost.

   • Port: The database port number. By default, this is 1527.

   • Database: The name of the Worklist Manager database. By default, this is WORKFLOWDB.

   • User Name: The user name under which the database schema was created. By default, this is WORKFLOW.

   • Password: The password for the above user. By default, this is WORKFLOW.

5. If you do not want to enter the password each time you connect to the database, select Remember Password.

6. Click OK.

7. Verify that the WORKFLOW schema is selected.

8. Click OK again.