Managing WebLogic Integration Solutions
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.
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.