Setting up the sql/mx database on nonstop – HP Integrity NonStop J-Series User Manual
Page 166
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