Configuring a Microsoft SQL Server JDBC provider and data source for the business process container

This topic describes how to configure a Microsoft SQL Server JDBC provider and data source for the business process container.

Steps for this task

  1. Change to the process choreographer directory by entering the command:
    cd install_root\ProcessChoreographer
  2. Run the configuration script by entering the command.
    install_root\bin\wsadmin -f create_ds_MsSql.jacl
        [-node <nodeName>] -server <serverName> 
        [-driverType ( Embedded | SequeLink )]
        [-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_MsSql.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. The default value is localhost.
    Embedded or SequeLink
    indicates which type of JDBC driver to configure for the database access. If nothing is specified Embedded is the default. Embedded specifies the ConnectJDBC driver that is embedded in WebSphere. SequeLink specifies the DataDirect SequeLink driver that is embedded in WebSphere.
    dbServerName
    is the name of the database server machine.
    dbPort
    is the port used on the database server. The default value is 1433 for Embedded and 19996 for SequeLink.
    databaseName
    is the optional name of the process choreographer database. The default value 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:

    install_root\bin\wsadmin -f create_ds_MsSql.jacl
        -server server1 -dbServer mymachine 
        -dbPort 1433 -dbName BPEDB -userid sa -password Password

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

Results

The Microsoft SQL Server JDBC provider and XA data source have been configured for the business process container.

What to do next

Configure the queue resources.



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

Library | Support | Terms of Use | Feedback