The way you create the database depends on the database platform you are using. Follow the appropriate procedure below for your database platform.
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.
In the NetBeans IDE, click the Services tab.
Expand Servers > GlassFish v2.1 > JBI > Service Engines.
Right-click sun-wlm-engine, and then select Start.
In the NetBeans IDE, click the Services tab.
Expand Databases, and then expand Drivers.
Right-click Java DB (Network), and then select Connect Using.
The New Database Connection dialog box appears.
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.
If you do not want to enter the password each time you connect to the database, select Remember Password.
Click OK.
Verify that the WORKFLOW schema is selected.
Click OK again.
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'; |
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; |