This topic describes how to configure a Sybase JDBC provider and
data source for the business process container.
- Change to the Business Process Choreographer directory: On
Windows, enter:
cd install_root\ProcessChoreographer
On
UNIX, enter: cd install_root/ProcessChoreographer
- 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 Business 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
- If you had problems using the script, you can perform Using the administrative console to configure the JDBC provider
and data source.
The Sybase JDBC provider and data source have been configured for
the business process container.
Configure the queue resources.