Managing WebLogic Integration Solutions

Configuring a Production Database

When preparing a production environment for WebLogic Integration, the production database must be configured to include the tables required by WebLogic Integration. To allow your database administrator to manage the process, the tables required are not created automatically. This section provides information about the scripts available to create the tables.

The SQL scripts that create the database tables used by WebLogic Integration can be found in the following directory:

	BEA_HOME/weblogic81/integration/dbscripts/vendor/

In this path, BEA_HOME represents the WebLogic Platform home directory, and vendor represents the vendor of the database you will be using in production mode. The following table describes the scripts.

Table A-1 WebLogic Integration Database Scripts

Script filename	Description
`wli_runtime.sql`	SQL that creates tables involved in WebLogic Integration runtime activity.
`wli_runtime_drop.sql`	SQL that drops tables created by `wli_runtime.sql`. Note: All runtime data is destroyed.
`wli_archive.sql`	SQL that creates tables used to store WebLogic Integration data for reporting and analysis.
`wli_archive_drop.sql`	SQL that drops tables created by `wli_archive.sql`. Note: All runtime data is destroyed.

Use your preferred SQL tool to run the scripts to create or drop the WebLogic Integration tables in your production database.

In addition to the WebLogic Integration tables, you must also create the database tables that store conversational state information. To learn how to create the required tables, see How Do I: Deploy a WebLogic Workshop Application to a Production Server? in the WebLogic Workshop help, at the following URL:

http://download.oracle.com/docs/cd/E13226_01/workshop/docs81/doc/en/workshop/guide/howdoi/howDeployWebLogicWorkshopWebServicestoaProductionServer.html

If you have trading partner management data, you can use the Bulk Loader to import the information. Refer to Using the Trading Partner Bulk Loader.