Configuring a Sybase JDBC provider and data source for the business process container

This topic describes how to configure a Sybase 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_Sybase.jacl
        [-node <nodeName>] -server <serverName> -dbPath <databasePath> 
        [-dbServer <dbServerName>] [-dbPort <port>] [-dbName <databaseName>]
        -userid <userID> -password <password>
    
    On UNIX, enter:
    install_root/bin/wsadmin.sh -f create_ds_Sybase.jacl
        [-node <nodeName>] -server <serverName> -dbPath <databasePath> 
        [-dbServer <dbServerName>] [-dbPort <port>] [-dbName <databaseName>]
        -userid <userID> -password <password>
    
    Where:
    wsadmin
    is located in the bin subdirectory of the IBM WebSphere Application Server installation directory.
    create_ds_Sybase.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, and on UNIX, the default directory is /opt/WebSphere/AppServer/ProcessChoreographer.
    nodeName
    is the optional node name. The default is the local node.
    serverName
    is the application server name.
    databasePath
    is the location where your Sybase system is installed. Note: On Windows you must use forward slashes (/) instead of back slashes (\) to specify the path. For example, if your JDBC driver is located in the path c:/Sybase/jConnect-5_2/classes/jconn2.jar your value for the dbPath must be c:/Sybase.
    dbServerName
    is the name of the database server machine. The default is the local host.
    dbPort
    is the port used on the database server. The default is 4100.
    databaseName
    is the name of the process choreographer database. If you do not specify a name, the default BPEDB is used.
    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_Sybase.jacl
        -server server1 -dbPath "c:/sybase" -dbServer mymachine 
        -dbPort 4100 -dbName BPEDB -userid sa -password SybaseAdminPassword

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

Results

The Sybase JDBC provider and data source have been configured for the business process container.

What to do next

Configure the queue resources.



Searchable topic ID:   t2codssy
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/t2codssy.html

Library | Support | Terms of Use | Feedback