Creating a database table

A DataStore collaboration object copies business objects into a database table.

Description

You must create this table in any database instance supported by the JDBCConnector. The database instance does not necessarily have to be on the same machine as the IBM® WebSphere® InterChange Server (ICS).

The database table must consist of two columns with the suggested names of ObjectKey and ObjectData. Specify values for these columns as shown in the table below. ObjectKey must be specified as a unique key for the table. If the database allows specification of the length of ObjectData, choose a value larger than the maximum anticipated length of the XML representation of the GBO being serialized. This value will vary according to the GBO being stored.

Database table description

Column name DB2® data type Microsoft® SQL Server data type Oracle data type
ObjectKey VARCHAR (length =255) if the value of the DataStore collaboration object's GENERATE_KEY configuration property is false.

Integer if the value of GENERATE_KEY is true.

VARCHAR (length =255) if the value of the DataStore collaboration object's GENERATE_KEY configuration property is false.

Integer if the value of GENERATE_KEY is true.

VARCHAR (length =255) if the value of the DataStore collaboration object's GENERATE_KEY configuration property is false.

Integer if the value of GENERATE_KEY is true.

ObjectData CLOB TEXT CLOB

Parent topic: Setting up the Datastore collaboration object