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 the Oracle Database Server
 
Configuring the Oracle Database Server
*To use an Oracle 8i database for the message store, configure the Oracle database server as follows
1. Create a user account that the Partner Manager can use to access the database.
2. Create the following tables and give the Partner Manager’s account read/write access to them.
Table
Column
Type
Length
WMTRANSACTION_Log
tid
VARCHAR
50
creationdate
DATE
message
VARCHAR
255
WMTransactions
tid
VARCHAR
50
sender
VARCHAR
50
receiver
VARCHAR
50
msgType
VARCHAR
50
package
VARCHAR
50
docURI
VARCHAR
50
flow
VARCHAR
50
lastError
VARCHAR
50
state
DECIMAL
wmTime
TIMESTAMP
Note:
If you grant the Partner Manager’s user account the permission to create tables, the Partner Manager will automatically create these tables for you the first time it connects to the database.