6.8.1 Deleting application information tables
Application information tables store settings related to the database session failover functionality set in a Web application.
The procedures for deleting the application information table are as follows:
-
Copy the template file to any location.
A template file is provided as an SQL file used for deleting a table. The storage locations of the template files for each used database are:
-
Storage location of template files when using HiRDB
In Windows: Application-Server-installation-directory\CC\sfo\sql\hirdb_delete_apptbl.sql
In UNIX: /opt/Cosminexus/CC/sfo/sql/hirdb_delete_apptbl.sql
-
Storage location of template files when using Oracle
In Windows: Application-Server-installation-directory\CC\sfo\sql\oracle_delete_apptbl.sql
In UNIX: /opt/Cosminexus/CC/sfo/sql/oracle_delete_apptbl.sql
-
-
Edit the template file.
Edit the template file in accordance with the preference information for a Web application and create an SQL file used for deleting a table. The following table describes change locations and change contents in a template file.
Table 6‒55: Change locations and change contents in a template file Change location
Change target
Change contents
HiRDB
Oracle
First line
First line
APPLICATION_ID
Change the application identifier of the application to be used.
None
First line
SCHEMA_NAME
Change the schema name of user connected to database.
-
Execute the SQL file created for table deletion.
For executing the SQL file, use SQL Executer when using HiRDB and SQL*Plus when using Oracle.