HP Integrity NonStop H-Series User Manual
Page 56
1.
Edit the
jpetstore_tables_script.sql
file to add the following:
•
<$datavol>
: specify the Guardian volume for the primary partition of the table. For
example:
$data01
•
: specify the owner of the schema. For example:
super.sashusr
•
: specify the location of the metadata tables for the catalog. For example:
\NSK01.$data01
•
: specify the designated subvolume name for the schema. For
example:
SASH2
NOTE:
The subvolume name must only be five characters long.
2.
Create a directory in OSS to place the database script files, using the command:
OSS> mkdir –p
For example:
OSS> mkdir –p /home/sash_usr/sash/spring/samples/jpetstore/dbconfig
NOTE:
<
NonStop SASH Home
> can be any working directory. It is suggested that you
create the
spring/samples/jpetstore/dbconfig
directory structure in <
NonStop
SASH Home
>.
3.
Copy the following scripts from the
\
spring\samples\jpetstore\
db
Windows directory to the
/
spring/samples/jpetstore/
dbconfig
OSS directory:
•
jpetstore_tables_script.sql
•
jpetstore_dataload_script.sql
NOTE:
•
The
jpetstore_tables_script.sql
script creates the SQL/MX database catalog,
schema, and tables for JPetStore.
•
The
jpetstore_dataload_script.sql
script loads the database with sample data.
4.
Go to the OSS directory, where the
jpetstore_tables_script.sql
and
jpetstore_dataload_script.sql
files are copied, using the OSS command:
OSS> cd
For example:
OSS> cd /home/sash_usr/sash/spring/samples/jpetstore/dbconfig
5.
Create the JPetStore database catalog, schema, and tables using the SQL/MX command:
mxci>> obey jpetstore_tables_script.sql;
NOTE:
By default, the
jpetstore_tables_script.sql
file creates the database catalog
name as
jpetstorecat
and schema name as
jpetstoresch
. If these names conflict with
any of the existing catalog and schema names, you must modify the database catalog and
schema names in the
jpetstore_tables_script.sql
script file. If you modify the
database catalog and schema names, the new names must be updated in the
jdbc.properties
file present in the
war\WEB-INF
directory, included in the
SAMPLES.zip
file.
6.
Load the sample data in the JPetStore database tables, using the SQL/MX command:
mxci>> obey jpetstore_dataload_script.sql;
The JPetStore database is set up on your NonStop system.
56
Installing Spring Framework