HP Integrity NonStop H-Series - Manual (Page 303)

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 <NonStop SASH Home>/hibernate/samples/eg/dbconfig
For example:
OSS> mkdir –p /home/sash_usr/sash/hibernate/samples/eg/dbconfig
NOTE: < NonStop SASH Home > can be any working directory. It is suggested that you
create the hibernate/samples/eg/dbconfig directory structure in < NonStop SASH
Home >.
3. Copy the caveatemptor_script.sql script from the <My SASH
Home>\hibernate\samples\eg\dbconfig Windows directory to the <NonStop SASH
Home>/hibernate/samples/eg/dbconfig OSS directory.
4. Go to the OSS directory where the caveatemptor_script.sql script is copied, using
the OSS command:
OSS> cd <NonStop SASH Home>/hibernate/samples/eg/dbconfig
For example:
OSS> cd /home/sash_usr/sash/hibernate/samples/eg/dbconfig
5. Create the Caveat Emptor database catalog, schema, and tables using the SQL/MX command:
mxci>> obey caveatemptor_script.sql;
NOTE: By default, the caveatemptor_script.sql script file creates the database
catalog auctionccat and schema auctionsch . If the database catalog name
auctionccat and schema name auctionsch already exist, or if you want to use a different
database catalog and schema name, modify the following:
•
database catalog and schema names in the caveatemptor_script.sql script file.
• database catalog and schema names in the hibernate.properties file present in
<My SASH Home>\hibernate\samples\eg directory present in SAMPLES.zip
file.
Setting up the Hibernate and JDBC environment on NonStop
To set the CLASSPATHs for Hibernate and JDBC/MX driver environment, complete the following
steps:
1. Modify the setenv script file as follows:
a. Set the value of hibernatehome variable to <NonStop Hibernate Home> OSS
directory.
For example, if <NonStop Hibernate Home> is /usr/tandem/sash/
hibernate-3.2.6 ,
Deploying and Running Sample Hibernate Application on NonStop 303