Configuring and Starting WebLogic Process Integrator

 

The following sections explain how to configure and start the WebLogic Process Integrator Server, Studio client application, and Worklist client application:

• Creating Database Tables

• Customizing and Starting WebLogic Process Integrator

 

---

Creating Database Tables

In order to run WebLogic Process Integrator, you must first create the required database tables. The \wlprocessintegrator\server\ddl directory contains SQL Data Definition Language (DDL) files to create the required tables. Use your database administrator tool to execute the appropriate DDL file.

• Oracle 8.1.5—Use wlpi_oracle.ddl

• Microsoft SQL Server 7.0—Use wlpi_mssql.ddl

• Sybase System 11—Use wlpi_sybase.ddl

 

---

Customizing and Starting WebLogic Process Integrator

Before you can use WebLogic Process Integrator, you need to customize the run-time environment by setting environment variables for each of the WebLogic Process Integrator components. The following sections explain how to set the environment variables and start the WebLogic Process Integrator components:

• Customizing and Starting the Server

• Customizing and Starting the Studio

• Customizing and Starting the Worklist

Customizing and Starting the Server

The following steps explain how to customize the WebLogic Process Integrator Server run-time environment and start the server.

Step 1. Edit the Server Environment Variables File

To edit the server environment variables file:

On Windows NT:

1. Navigate to \wlprocessintegrator\Server using Windows NT Explorer.

2. Right click setWLPIServerEnv.cmd to edit the file.

3. Set the following variables to values appropriate for your environment:

   1. JAVA_HOME

      This variable represents the root of the Java run-time environment (for example, c:\jdk1.2.2). WebLogic Process Integrator expects to find a Java archive called jre\lib\rt.jar in the subdirectory of this path.

   2. WL_HOME

      This variable represents the root of the WebLogic Server installation directory (for example, c:\weblogic).

   3. JDBC_DRIVER

      This variable represents the directory path containing the JDBC driver classes, .jar, or .zip. Set this variable similar to the following values based on your database:

   4. WebLogic jDriver for Oracle

      %WL_HOME%\lib\classes12_01.zip;%WL_HOME%\lib\nls_charset12_01.zip

   5. WebLogic jDriver for SQL Server

      %WL_HOME%\mssqlserver4\classes

   6. Sybase jConnect

      %WL_HOME%\lib\jConnect.jar

4. Save your changes and close the file.

On UNIX:

1. Change directories to the wlpi/Server directory:

   cd wlpi/Server

2. Edit setwlpiserverenv.sh to make the following changes:

   1. Set JAVA_HOME to match the JDK directory on your machine.

   2. Set WL_HOME to match your WebLogic Server home directory.

   3. Set JDBC_DRIVER_CLASSPATH to point to your JDBC Driver.

      For example, if you have installed JDK in /home/wlpiuser/jdk1.2.2 and WebLogic server in /home/wlpiuser/weblogic5.1, then edit the following lines in setwlpiserverenv.sh:

      JAVA_HOME=/home/wlpiuser/jdk1.2.2
      WL_HOME=/home/wlpiuser/weblogic5.1
      JDBC_DRIVER_CLASSPATH=$WL_HOME/lib/classes12_01.zip:\
      $WL_HOME/lib/nls_charset12_01.zip

3. Save your changes and close the file.

4. Launch a sh or ksh.

5. Run the environment script:

   . ./setwlpiserverenv.sh

Step 2. Edit the weblogic.properties File

To edit the weblogic.properties file:

1. Navigate to the weblogic.properties file in the Server directory of the WebLogic Process Integrator installation.

   • On Windows NT, navigate to \wlprocessintegrator\Server.

   • On UNIX, change directories to the wlpi/Server directory

     cd wlpi/Server

2. Use a text editor to open the weblogic.properties file.

3. Scroll down to the "WLPI Specific Settings" section.

4. Uncomment the JDBC driver section for your database by removing the pound (#) characters.

5. Specify your database name, host server, and port in the line beginning with url=. Refer to Listing 4-1, Listing 4-2, and Listing 4-3 for the appropriate values based on your database.

6. Set user= and password= to an account with create/update/delete privileges on the database server. Refer to Listing 4-1, Listing 4-2, and Listing 4-3 for the appropriate values based on your database.

   Listing 4-1 JDBC Connection Pool Properties for Oracle Thin

   ---

   # Connection pool to Oracle using Thin
   weblogic.jdbc.connectionPool.wlpiPool=\
   	url=jdbc:oracle:thin:@MyOracleHost:1521:MyDB,\
   	driver=oracle.jdbc.driver.OracleDriver,\
   	loginDelaySecs=1,\
   	initialCapacity=1,\
   	maxCapacity=3,\
   	capacityIncrement=1,\
   	allowShrinking=true,\
   	shrinkPeriodMins=15,\
   	refreshTestMinutes=10,\
   	props=user=MyUserName;password=MyPassword

   ---

   Listing 4-2 JDBC Connection Pool Properties for MS SQL Server

   ---

   # Connection pool for MS SQL Server 7.0 database connectivity
   weblogic.jdbc.connectionPool.wlpiPool=\
   	url=jdbc:weblogic:mssqlserver4:MyDB@MySqlServerHost\
   	:1433?sql7=true,\
   	driver=weblogic.jdbc.mssqlserver4.Driver,\
   	loginDelaySecs=1,\
   	initialCapacity=1,\
   	maxCapacity=2,\
   	capacityIncrement=1,\
   	allowShrinking=true,\
   	shrinkPeriodMins=15,\
   	refreshTestMinutes=10,\
   	props=user=MyUserName;password=MyPassword

   ---

   Listing 4-3 JDBC Connection Pool Properties for Sybase jConnect

   ---

   # Connection pool to Sybase using jConnect
   weblogic.jdbc.connectionPool.wlpiPool=\
           url=jdbc:sybase:Tds:MySybaseHost:5000/MyDB,\
           driver=com.sybase.jdbc.SybDriver,\
           loginDelaySecs=1,\
           initialCapacity=1,\
           maxCapacity=3,\
           capacityIncrement=1,\
           allowShrinking=true,\
           shrinkPeriodMins=15,\
           refreshTestMinutes=10,\
           props=user=MyUserName;password=MyPassword

   ---

7. Edit the MailSession property using the value shown in Listing 4-4.

   Listing 4-4 Mail Session Property

   ---

   # Mail session weblogic.resource.MailSession.wlpi.MailSession=mail.from=\
   [e-mail],mail.host=smtp.mycompany.com

   ---

8. Save your changes and close the file.

Step 3. Configure the Mail Session Properties for the Workflow Processor EJBs

To configure the mail-session properties:

1. Run the WebLogic EJB deployer tool.

   On Windows NT:

   1. Navigate to \wlprocessintegrator\Server using Windows NT Explorer.

   2. Double click DeployerTool.cmd to start the WebLogic EJB deployer tool.

      On UNIX:

   3. Change directories to the wlpi/Server directory:

      cd wlpi/Server

   4. Run the WebLogic EJB deployer tool:

      . ./deployertool.sh

2. Navigate to Deployer—>Beans—>WorkflowProcessor—>Environment Entries. The environment entries for the Workflow Processor EJB are displayed in the upper-right panel.

   Figure 4-1 WebLogic EJB Deployer Tool Showing Environment Entries

   

3. Define the following mail-session properties by double-clicking in the text field you want to edit and typing the appropriate value:

   • mail/sender-name

   • mail/sender-address

   • mail/mail-user

   • mail/mail-transport-protocol

   • mail/mail-host

   • mail/mail-from

   • mail/mail-debug

   • mail/authenticator-password

   • mail/authenticator-id

4. Select File—>Save to save your changes and exit.

   For more information, see Deploying EJBs with the Deployer Tool at http://www.weblogic.com/docs51/classdocs/API_ejb/EJB_deploy.html

Step 4. Edit the rdbmsrealm.properties File

To edit the rdbmsrealm.properties file:

1. Navigate to the rdbmsrealm.properties file in the Server directory of the WebLogic Process Integrator installation.

   • On Windows NT, navigate to \wlprocessintegrator\Server.

   • On UNIX, change directories to the wlpi/Server directory

     cd wlpi/Server

2. Use a text editor to open the rdmsrealm.properties file.

3. Uncomment the JDBC driver section for your database by removing the pound (#) characters.

4. Specify your database name, host server, and port in the line beginning with dbURL=. Use the same settings as those shown for url= in Listing 4-1, Listing 4-2, and Listing 4-3 for your database.

5. Set dbUser= and dbPassword= to the appropriate user account.

6. Save your changes and close the file.

Step 5. Start the WebLogic Process Integrator Server

To start the WebLogic Process Integrator Server:

On Windows NT:

Choose Start—>Programs—>BEA WebLogic Process Integrator —>Server from the Windows NT Start menu.

On UNIX:

1. Change directories to the wlpi/Server directory:

   cd wlpi/Server

2. Run the script wlpi.sh:

   . ./wlpi.sh

Customizing and Starting the Studio

The following steps explain how to customize the WebLogic Process Integrator Studio run-time environment and start the Studio.

Step 1. Edit the Studio Environment Variables File

To edit the Studio environment variables file:

On Windows NT:

1. Navigate to \wlprocessintegrator\Studio\bin using Windows NT Explorer.

2. Right click setWLPIStudioEnv.cmd to edit the file.

3. Set the JAVA_HOME variable to a value appropriate for your environment.

   This variable represents the root of the Java run-time environment (for example, c:\jdk1.2.2). WebLogic Process Integrator expects to find a Java archive called jre\lib\rt.jar in the subdirectory of this path.

On UNIX:

1. Change directories to the /wlpi/Studio/bin directory:

   cd wlpi/Studio/bin

2. Edit the setwlpistudio.sh script to include the correct JDK directory path for the JAVA_HOME variable.

3. Set the environment by running setwlpistudio.sh:

   . ./setwlpistudio.sh

Step 2. Start the WebLogic Process Integrator Studio

To start the WebLogic Process Integrator Studio:

On Windows NT:

1. Choose Start—>Programs—>BEA WebLogic Process Integrator—>Studio from the Windows NT Start menu.

On UNIX:

1. Change directories to the wlpi/Studio/bin directory:

   cd wlpi/Studio/bin

2. Run the studio.sh script:

   . ./studio.sh

Customizing and Starting the Worklist

The following steps explain how to customize the WebLogic Process Integrator Worklist run-time environment and start the Worklist.

Step 1. Edit the Worklist Environment Variables File

On Windows NT:

1. Navigate to \wlprocessintegrator\Worklist\bin using Windows NT Explorer.

2. Right click setWLPIWorklistEnv.cmd to edit the file.

3. Set the JAVA_HOME variable to a value appropriate for your environment.

   This variable represents the root of the Java run-time environment (for example, c:\jdk1.2.2). WebLogic Process Integrator expects to find a Java archive called jre\lib\rt.jar in the subdirectory of this path.

On UNIX:

1. Change directories to the wlpi/Worklist/bin directory:

   cd wlpi/Worklist/bin

2. Edit the setwlpistudio.sh script to include the correct JDK directory path for the JAVA_HOME variable.

3. Set the environment by running setwlpiworklist.sh:

   . ./setwlpiworklist.sh

Step 2. Start the WebLogic Process Integrator Worklist

To start the WebLogic Process Integrator Worklist:

On Windows NT:

Choose Start—>Programs—>BEA WebLogic Process Integrator—>Worklist from the Windows NT Start menu.

On UNIX:

1. Change directories to the wlpi/Worklist/bin directory.

   cd wlpi/worklist/bin

2. Run the worklist.sh script:

   . ./worklist.sh