Oracle Workflow Guide
Release 2.6.2

Part Number A95265-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

Step 14 Setting Up the Java Function Activity Agent

To execute external Java function activities, you must set up the Java Function Activity Agent. This functionality is currently only available for the standalone version of Oracle Workflow. The Java Function Activity Agent dequeues the messages related to external Java activities from the 'Outbound' queue for external function processing, calls the appropriate Java functions, and places the results on the 'Inbound' queue for external function processing.

Note: These 'Outbound' and 'Inbound' queues are separate from the queues used for the Business Event System. See: Workflow Queue APIs.

After a Java function completes, you must run a background engine to process the 'Inbound' queue and complete the function activity. See: Setting Up Background Engines.

Some standard Workflow activities are external Java function activities and require the Java Function Activity Agent. You can also define your own external Java function activities. See: Standard Activities, To Create a Function Activity, and Standard API for Java Procedures Called by Function Activities.

To run the Java Function Activity Agent, you must have Java Runtime Environment (JRE) Version 1.1.8, or a higher 1.1.x version, installed.

Note: The Java Runtime Environment is available for download from http://www.javasoft.com.

Context: You need to perform this step only once.

Starting the Java Function Activity Agent

If you are using the standalone version of Oracle Workflow, you can run scripts provided by Oracle Workflow to start the Java Function Activity agent. You can also start the agent manually.

When you start the Java Function Activity Agent, you must specify the database connection details. You can also optionally specify the character set and the JDBC driver type that you want to use.

You use different commands to start the agent depending on whether you are running it from a script or manually, which platform you are running it on, and which options you want to specify.

Starting the Java Function Activity Agent From a Script

If you are using the standalone version of Oracle Workflow, you can run scripts called wfjvlsnr.csh or wfjvlsnr.bat to start the Java Function Activity Agent on UNIX or on Windows NT, respectively. These scripts are located on your server in the Oracle Workflow admin subdirectory.

If you define your own external Java function activities, you must edit the scripts to include the path to the JAR files containing your custom Java classes. The custom class files should reside on the same platform where the Java Function Activity Agent is run. The Java Function Activity Agent does not need to reside on the same tier as the database, however.

You can use commands with different syntax to run the scripts, depending on your platform and the options you want to specify.

Running the wfjvlsnr.csh Script on UNIX For example, you can use the following command to run the wfjvlsnr.csh script on UNIX, if you want to use the default JDBC OCI8 driver:

wfjvlsnr.csh <user_name>/<password>@<connect_string> [<character_set>]

Replace the parameters in the command as follows:

You can also use the following command to run the wfjvlsnr.csh script on UNIX, if you want to specify the JDBC driver type to use:

wfjvlsnr.csh "<user_name> <password> <connect_string> [<JDBC_driver>]" [<character_set>]

Replace the parameters in the command as follows:

Note: The connection details, including the user name, password, connect string, and JDBC driver type, must be enclosed in double quotes to separate them from the character set parameter.

Running the wfjvlsnr.bat Script on Windows NT On Windows NT, you can use the following command to run the wfjvlsnr.bat script, if you want to use the default JDBC OCI8 driver:

wfjvlsnr.bat <user_name>/<password>@<connect_string> [<character_set>]

Replace the parameters in the command as follows:

You can also use the following command to run the wfjvlsnr.bat script on Windows NT, if you want to specify the JDBC driver type to use:

wfjvlsnr.bat "<user_name> <password> <connect_string> [<JDBC_driver>]" [<character_set>]

Replace the parameters in the command as follows:

Note: The connection details, including the user name, password, connect string, and JDBC driver type, must be enclosed in double quotes to separate them from the character set parameter.

Starting the Java Function Activity Agent Manually

To start the Java Function Activity Agent manually, run JRE against oracle.apps.fnd.wf.WFFALsnr, specifying your CLASSPATH, the user name and password of your Oracle Workflow database account, and the database connect string. You can also optionally specify the character set and the JDBC driver type that you want to use.

The CLASSPATH must point to the Java Runtime Environment, the directory containing the Workflow JAR files, the Oracle XML parser, the Oracle JDBC implementation, and the following Workflow JAR files:

Note: In the standalone version of Oracle Workflow with Oracle9i, the Workflow JAR files are located in the <ORACLE_HOME>/jlib directory. In the version of Oracle Workflow embedded in Oracle Applications, the Workflow JAR files are located in the <ORACLE_HOME>/wf/java/oracle/apps/fnd/wf/jar/ directory.

If you define your own external Java function activities, you must also include the JAR files containing your custom Java classes in the CLASSPATH. The custom class files should reside on the same platform where the Java Function Activity Agent is run. The Java Function Activity Agent does not need to reside on the same tier as the database, however.

You can use commands with different syntax to start the Java Function Activity Agent manually, depending on your platform and the options you want to specify.

Starting the Java Function Activity Agent on UNIX For example, you can use the following command to start the Java Function Activity Agent on UNIX, if you want to use the default JDBC OCI8 driver:

jre -classpath "$<JREPATH>/rt.jar:$<Workflow_JAR_file_directory>:
$<Workflow_JAR_file_directory>/wfjava.jar:$<ORACLE_HOME>/wf/
xml/java/lib/xmlparserv2.jar:$<Workflow_JAR_file_directory>/wfapi.jar:$<ORACLE_HOME>/jdbc/lib/classes111.zip:
$<Workflow_JAR_file_directory>/<Share_JAR_file>:
$<Workflow_JAR_file_directory>/<Ewt_JAR_file>:
$<Workflow_JAR_file_directory>/<Swing_JAR_file>:" [-DCHARSET=<character_set>] oracle.apps.fnd.wf.WFFALsnr <user_name>/<password>@<connect_string>

In this command, you can optionally use the -DCHARSET option to specify the character set that you want to use. If you do not specify a character set, Oracle Workflow uses UTF8 by default.

Replace the parameters in the command as follows:

You can also use the following command to start the Java Function Activity Agent on UNIX, if you want to specify the JDBC driver type to use:

jre -classpath "$<JREPATH>/rt.jar:$<Workflow_JAR_file_directory>:
$<Workflow_JAR_file_directory>/wfjava.jar:$<ORACLE_HOME>/wf/
xml/java/lib/xmlparserv2.jar:$<Workflow_JAR_file_directory>/wfapi.jar:$<ORACLE_HOME>/jdbc/lib/classes111.zip:
$<Workflow_JAR_file_directory>/<Share_JAR_file>:
$<Workflow_JAR_file_directory>/<Ewt_JAR_file>:
$<Workflow_JAR_file_directory>/<Swing_JAR_file>:" [-DCHARSET=<character_set>] oracle.apps.fnd.wf.WFFALsnr <user_name> <password> <connect_string> [<JDBC_driver>]

In this command, you can optionally use the -DCHARSET option to specify the character set that you want to use. If you do not specify a character set, Oracle Workflow uses UTF8 by default.

Replace the parameters in the command as follows:

Starting the Java Function Activity Agent on Windows NT On Windows NT, you can use the following command to start the Java Function Activity Agent, if you want to use the default JDBC OCI8 driver:

jre -classpath ";<JREPATH>\rt.jar;<Workflow_JAR_file_directory>;
<Workflow_JAR_file_directory>\wfjava.jar;<ORACLE_HOME>\wf\
xml\java\lib\xmlparserv2.jar;<Workflow_JAR_file_directory>\
wfapi.jar;<ORACLE_HOME>\jdbc\lib\classes111.zip;
<Workflow_JAR_file_directory>\<Share_JAR_file>;
<Workflow_JAR_file_directory>\<Ewt_JAR_file>;
<Workflow_JAR_file_directory>\<Swing_JAR_file>;"
-nojit [-DCHARSET=<character_set>]
oracle.apps.fnd.wf.WFFALsnr <user_name>/<password>@<connect_string>

In this command, you can optionally use the -DCHARSET option to specify the character set that you want to use. If you do not specify a character set, Oracle Workflow uses UTF8 by default.

Replace the parameters in the command as follows:

You can also use the following command to start the Java Function Activity Agent on Windows NT, if you want to specify the JDBC driver type to use:

jre -classpath ";<JREPATH>\rt.jar;<Workflow_JAR_file_directory>;
<Workflow_JAR_file_directory>\wfjava.jar;<ORACLE_HOME>\wf\
xml\java\lib\xmlparserv2.jar;<Workflow_JAR_file_directory>\
wfapi.jar;<ORACLE_HOME>\jdbc\lib\classes111.zip;
<Workflow_JAR_file_directory>\<Share_JAR_file>;
<Workflow_JAR_file_directory>\<Ewt_JAR_file>;
<Workflow_JAR_file_directory>\<Swing_JAR_file>;"
-nojit [-DCHARSET=<character_set>]
oracle.apps.fnd.wf.WFFALsnr <user_name> <password>
<connect_string> [<JDBC_driver>]

In this command, you can optionally use the -DCHARSET option to specify the character set that you want to use. If you do not specify a character set, Oracle Workflow uses UTF8 by default.

Replace the parameters in the command as follows:

Stopping the Java Function Activity Agent

Normally, the Java Function Activity Agent runs as a perpetual job. However, you can stop the agent by running a script called wfjvstop.sql, located in the admin/sql subdirectory on your Oracle Workflow server. This script places a stop message on the 'Outbound' queue. See: wfjvstop.sql.

Note: If you are running more than one Java Function Activity Agent simultaneously, you must run the wfjvstop.sql script once for each Java Function Activity Agent.


         Previous  Next          Contents  Index  Glossary


Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.