HP Integrity NonStop J-Series - Manual (Page 72)

NOTE: The database catalog, schema, and table creation script
empinfo_tables_script.sql is included in the SAMPLES.zip file.
For information on the empinfo_tables_script.sql, see “EmpInfo Database Script” (page 319) .
To create a database catalog, schema, and table on NonStop, complete the following steps:
1.
Copy the empinfo_tables_script.sql script from the <My SASH
Home>\spring\getting-started\dbconfig
Windows directory to the <NonStop
SASH Home>/spring/my_samples/empinfo/dbconfig OSS directory.
2. Go to the OSS directory, where the empinfo_tables_script.sql script is copied, using
the OSS command:
OSS> cd <NonStop SASH Home>/spring/my_samples/empinfo/dbconfig
For example:
OSS> cd /home/sash_usr/sash/spring/my_samples/empinfo/dbconfig
3. Create the EmpInfo application database catalog, schema, and tables using the SQL/MX
command:
OSS> obey empinfo_tables_script.sql;
NOTE: By default, the empinfo_tables_script.sql script creates the database
catalog name as empinfocat and the schema name as empinfosch. If these database
catalog and schema names conflict with any of the existing catalog and schema names on
the NonStop system, modify the database catalog and schema in the
empinfo_tables_script.sql
script file.
If you modify the database catalog and schema names, the new database catalog names
must be updated in the EmpInfo/WebContent/WEB-INF/jdbc.properties file.
The project directory structure for the EmpInfo application must appear as follows:
72 Spring Framework