User Manual

4. Go to <My SASH Home>\hibernate\samples\web\target and run the
following commands:
command prompt> cd <My SASH Home>\hibernate\samples\web\target
command prompt> jar uf hibernate-tutorial-web-3.5.0-CR-2.war WEB-INF\
lib\hibernate3sqlmx.jar WEB-INF\lib\t4sqlmx.jar
The hibernate3sqlmx.jar and t4sqlmx.jar files are copied to
<My SASH Home>\hibernate\samples\web\target\
hibernate-tutorial-web-3.5.0-CR-2.war\WEB-INF\lib.
Setting up the SQL/MX database on NonStop
To set up the SQL/MX database for EventManager on a NonStop system, complete the following
steps:
1. Edit the <My SASH Home>\hibernate\samples\web\dbconfig\
evenmanager_script.sql:
• <$datavol>: specify the Guardian volume for the primary partition of the table. For
example: $data01.
• <user>: specify the owner of the schema. For example: super.sashusr.
• <node.$vol>: specify the location of the metadata tables for the catalog. For example:
\NSK01.$data01.
• <subvol reference>: specify the designated subvolume name for the schema. For
example: SASH1.
NOTE: The subvolume name is always prefixed by ZSD and must have eight characters
(including ZSD).
2. Create a directory in OSS to place the database script files:
OSS> mkdir -p <NonStop SASH Home>/hibernate/samples/web/dbconfig
For example:
OSS> mkdir -p /home/sash_usr/sash/hibernate/samples/web/dbconfig
NOTE: <NonStop SASH Home> can be any working directory. It is suggested that you
create the hibernate/samples/web/dbconfig directory structure in <NonStop SASH
Home>.
3. Copy the evenmanager_script.sql script from the <My SASH
Home>\hibernate\samples\web\dbconfig Windows directory to the <NonStop SASH
Home>/hibernate/samples/web/dbconfig OSS directory.
4. Go to the OSS directory where the evenmanager_script.sql script is copied:
OSS> cd <NonStop SASH Home>/hibernate/samples/web/dbconfig
For example:
OSS> cd /home/sash_usr/sash/hibernate/samples/web/dbconfig
5. Create the EventManage database catalog, schema, and tables:
mxci>> obey evenmanager_script.sql;
166 Installing the Hibernate Framework