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