ANT target: ConfigureDatabase

ConfigureDatabase creates a database with schema, and populates the schema with the WebSphere Commerce bootstrap data.

 

Called by:

CreateInstance

 

Calls:

• CreateDatabase

• CreateSchema

• EnableTriggersAndPopulateSchema

 

Prerequisites:

The createInstance.properties file must exist for this Ant target to work. For information on generating the properties file, see ANT targets.

 

Required parameters:

instance

The name of the WebSphere Commerce instance with which you are working (for example, demo).

merchantKey

The WebSphere Commerce site merchant key.

siteAdminPassword

The WebSphere Commerce site administrator's password.

AIX|Linux|Solaris|Windows:

dbaPassword

The database administrator's password.

dbUserPassword

The WebSphere Commerce database user's password.

 

Example

• AIX|Linux|Solaris|WC_installdir/bin/config_ant.sh -DinstanceName=instance -DmerchantKey=merchantKey -DsiteAdminPassword=siteAdminPassword -DdbaPassword=dbaPassword -DdbUserPassword=dbUserPassword ConfigureDatabase

• I5/OS: WC_installdir/bin/config_ant.sh -DinstanceName=instance -DmerchantKey=merchantKey -DsiteAdminPassword=siteAdminPassword -DdbUserPassword=dbUserPassword ConfigureDatabase

• Windows:

  WC_installdir/bin/config_ant.bat -DinstanceName=instance -DmerchantKey=merchantKey -DsiteAdminPassword=siteAdminPassword -DdbaPassword=dbaPassword -DdbUserPassword=dbUserPassword ConfigureDatabase

 

Recovery:

1. If an error occurs, review the following log files:

   • AIX|Linux|Solaris|Windows:

     • WC_installdir/instances/instance/logs/createInstanceANT.log

     • WC_installdir/instances/instance/logs/createInstanceANT.err.log

   • I5/OS|

     • WC_userdir/instances/instance/logs/createInstanceANT.log

     • WC_userdir/instances/instance/logs/createInstanceANT.err.log

2. Identify which ANT target of ConfigureDatabase failed.

3. Resolve the problem.

4. Drop the database or clean up the Oracle Schema.

5. Execute the failed target and the remaining subsequent targets OR simply execute the ConfigureDatabase target again to call all sub-targets.

• ANT target: CreateDatabase
  CreateDatabase creates a database on a local or remote server for use by the WebSphere Commerce instance.

• ANT target: CreateSchema
  CreateSchema creates the WebSphere Commerce tables, auxiliaries, keys, indicies, views, and triggers.

• ANT target: EnableTriggersAndPopulateSchema
  EnableTriggersAndPopulateSchema creates stored procedures, enables the triggers, and massloads the WebSphere Commerce bootstrap data and NL (supported languages) data. If you choose to use an existing WebSphere Commerce schema, ensure that no bootstrap data and/or stored procedures already exist. Otherwise, this target will not execute successfully.

Related Concepts

ANT targets