This topic describes how to configure a Microsoft SQL Server JDBC
provider and data source for the business process container.
- Change to the Business Process Choreographer directory by entering
the command:
cd install_root\ProcessChoreographer
- 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 Business 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
- If you had problems using the script, you can use the administrative console to configure the JDBC provider
and data source.
The Microsoft SQL Server JDBC provider and XA data source have been
configured for the business process container.
Configure the queue resources.