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 | Using a Database as the Message Store | Configuring the database server
 
Configuring the database server
*On the database server
1. Establish a user account that Partner Manager can use to access the database.
2. Have your database administrator create the following tables in the database. Make sure that the user account you created in the previous step has read and write access to these tables.
Table
Columns
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
INTEGER
wmTime
DATE