OnRamp for Commerce One MarketSite 3.5 SP1 | webMethods OnRamp for Commerce One MarketSite Adapter Documentation | webMethods OnRamp for CommerceOne MarketSite Adapter Installation and User’s Documentation | Using the Partner Manager | Using the Message Store | Configuring the Location of the Message Store | Configuring the Message Store on Oracle 8i | Configuring webMethods Integration Server
 
Configuring webMethods Integration Server
*On webMethods Integration Server
1. Install the Oracle 8i thin driver classes111.zip file.
2. Edit the server.bat file (under Windows) or the server.sh file (under Unix) and add the JDBC driver to the classpath statement. (These files reside in the Integration Server_directory \bin directory.)
3. Start Integration Server Administrator and use the Database command on the Adapter menu to define an alias (a named set of connection parameters) called “transactions” for the Oracle database. When you add this alias, specify the following information in the Details section of the New DB Alias screen. For more information about adding an alias for a database server, see the WmDB User’s Guide.
In this field...
Specify...
Alias
The following string:

transactions
Type this string exactly as it appears above, using only lowercase letters.
DB URL
The URL for the Oracle database, which is usually specified in the following format:
jdbc:oracle:thin:username/password@hostname:portnumber:DatabaseName
where:
*username and password are the username and password you want to use to log on to the server. These are generally not needed, since the database framework will use the DBUsername and the DBPassword fields.
*hostname is the host name of the Oracle server.
*portnumber identifies the port on which the Oracle server listens for incoming requests.
*DatabaseName is the name of the database.
DB Username
The user ID that you created for the Partner Manager in step 1 of Configuring the Oracle Database Server. This is the user ID that the Partner Manager will use to connect to the Oracle database.
Note:
When the Partner Manager connects to the database, it attempts to create the message store tables if they do not exist. Before using the Partner Manager with Oracle 8i for the first time, make sure that the tables listed in step 2 of Configuring the Oracle Database Server exist on the Oracle server or that the user ID specified in DB URL is authorized to create tables.
DB Password
The password associated with the user account specified in DB Username.
Minimum Connections
The minimum number of connections to pool.
Maximum Connections
The maximum number of connections to have in the pool. When the maximum number of connections are open, then the next call to get a connection from the pool will wait until a connection is available (i.e., re-added to the pool).
Expiration Time (ms)
The amount of time to wait before discarding a cached connection from the pool.
Loaded Drivers
The class name of the JDBC driver.
Example:
oracle.jdbc.driver.OracleDriver
4. Edit the server configuration file to enable database logging. To do this, open Integration Server_directory \config\server.cnf with a text editor and add the following statement to it:
watt.PartnerMgr.xtn.store=db