Configuring an Oracle JDBC provider and data source for the business process container

This topic describes how to configure an Oracle JDBC provider and data source for the business process container.

Steps for this task

  1. Change to the process choreographer directory:
    On Windows, enter:
    cd install_root\ProcessChoreographer
    On UNIX, enter:
    cd install_root/ProcessChoreographer
  2. Run the configuration script.
    On Windows, enter:
    install_root\bin\wsadmin -f create_ds_Oracle.jacl 
        [-node <nodeName>] -server <serverName>
        [-driverType ( oci8 | thin ) ] 
        [-dbServer <dbServerName>] [-dbPort <port>]
        -dbPath <databasePath> [-tnsName <databaseName>] 
        -userid <userid> -password <password>
    On UNIX, enter:
    install_root/bin/wsadmin.sh -f create_ds_Oracle.jacl
        [-node <nodeName>] -server <serverName> 
        [-driverType ( oci8 | thin ) ] 
        [-dbServer <dbServerName>] [-dbPort <port>]
       -dbPath <databasePath> [-tnsName <databaseName>] 
        -userid <userid> -password <password>
    Where:
    wsadmin
    is located in the bin subdirectory of the IBM WebSphere Application Server installation directory.
    create_ds_Oracle.jacl
    is the script file that performs the configuration within WebSphere. It is located in the ProcessChoreographer subdirectory of the IBM WebSphere Application Server installation directory. For example, on a default Windows installation, it is in the directory c:\Program Files\WebSphere\AppServer\ProcessChoreographer.
    nodeName
    is the optional node name.
    serverName
    is the application server name.
    oci8 or thin
    indicates which JDBC driver to configure for the database access. If nothing is specified oci8 is the default, which selects the Oracle OCI JDBC driver. thin selects the Oracle thin JDBC driver. For performance reasons, oci8 is recommended.
    dbServerName
    is the machine name of the server that hosts the database. This is only required for the thin driver.
    port
    is the port number where the database server listens to JDBC requests. This is only required for the thin driver. If no value is specified, the default value 1521 is used.
    databasePath
    is the location where your Oracle system is installed. Note: On Windows you must use forward slashes (/) instead of back slashes (\) to specify the path, for example, "c:/oracle/ora90".
    databaseName
    is the TNS name. This is only required for the oci8 driver and must match the name used for the process choreographer database in the file tnsnames.ora. If no value is specified the default used is BPEDB.
    userid
    is the user ID for accessing the database. This must be the same user ID that was used to create the database.
    password
    is the password for userid.

    For example, on Windows:

    install_root\bin\wsadmin -f create_ds_Oracle.jacl
        -server server1 -dbPath "c:/oracle/ora90" -tnsName BPEDB 
        -userid system -password OraclePassword

  3. If you had problems using the script, you can use the administrative console to configure the JDBC provider and data source.

Results

The Oracle JDBC provider, an XA and a non-XA data source have been configured for the business process container.

What to do next

Configure the queue resources.



Searchable topic ID:   t2codsor
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/workflow/tasks/t2codsor.html

Library | Support | Terms of Use | Feedback