Creating the Worklist Manager Database

The way you create the database depends on the database platform you are using. Follow the appropriate procedure below for your database platform.

• Creating the Database for JavaDB (Derby)

• Creating the Database for MySQL

• Creating the Database for Oracle

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.

Creating the Database for MySQL

To use MySQL server for the Worklist Manager database, create a database and user by running the following SQL commands. Run these commands by logging into MySQL as the root user. You can change the name of the database from WLMSE_USER_DB, and you can change the name of the user from WLMSE_USER.

CREATE DATABASE WLMSE_USER_DB;
 GRANT ALL ON WLMSE_USER_DB.* TO 'WLMSE_USER'@'%' IDENTIFIED BY 'WLMSE_USER';

Creating the Database for Oracle

To use Oracle for the Worklist Manager database, create a tablespace and user in an Oracle instance using the SQL commands below. You can use any database name in place of WLMSE_USER_DB, and any user name and password in place of WLMSE_USER.

CREATE TABLESPACE "WLMSE_USER_DB"
 DATAFILE
   'WLMSE_USER_DB1.dat' SIZE 2000M,
   'WLMSE_USER_DB2.dat' SIZE 2000M;

CREATE USER WLMSE_USER IDENTIFIED BY WLMSE_USER
DEFAULT TABLESPACE WLMSE_USER_DB
QUOTA UNLIMITED ON WLMSE_USER_DB
TEMPORARY TABLESPACE temp
QUOTA 0M ON system

GRANT CREATE session to WLMSE_USER;
GRANT CREATE table to WLMSE_USER;
GRANT CREATE procedure to WLMSE_USER;
GRANT CREATE sequence to WLMSE_USER;

-- To run these commands you need to be logged in as "sys as sysdba"
grant select on sys.dba_pending_transaction to WLMSE_USER;
grant select on sys.pending_trans$ to WLMSE_USER;
grant select on sys.dba_2pc_pending to WLMSE_USER;
grant execute on sys.dbms_system to WLMSE_USER;
grant select on SYS.dba_2pc_neighbors to WLMSE_USER;
grant force any transaction to WLMSE_USER;