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 Microsoft SQL Server 7.x | Configuring the SQL Server
 
Configuring the SQL Server
*To use an SQL 7.x database as the message store, configure the SQL Server as follows
1. Create a user account that the Partner Manager can use to access the database.
2. Create a user-defined data type named Date that has the data type “datetime.”
3. Create the following tables and give the Partner Manager’s account read/write access to them.
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
Note:
If you grant the Partner Manager’s user account permission to create tables, the Partner Manager will automatically create these tables for you the first time it connects to the database.