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

Table 5-4 Jakarta Commons Dependency JAR Files
Source Location Dependency JAR Files
<Spring Home>/lib/jakarta-commons commons-collections.jar
<Spring Home>/lib/jakarta-commons commons-lang.jar
If you plan to use the JDBC Type 4 driver, you must add the JAR file of the JDBC Type 4 driver
to the EmpInfo project library.
Table 5-5 JDBC Type 4 Dependency JAR File
Source Location Dependency JAR File
<JDBC T4 installation directory>\lib t4sqlmx.jar
To add the dependency JAR files in the project library path and to resolve the J2EE module
dependency on these JAR files, follow the instructions described in the
Adding Dependency JAR
Files in the Project Library Path section.
Creating Database Catalog, Schema, and Tables on NonStop
This section describes the steps to create the database catalog, schema, and tables on your NonStop
system.
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 the EmpInfo Database Script .
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 /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:
mxci>> 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
your 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.
For information on the empinfo_tables_script.sql , see the EmpInfo Database Script .
Your project directory structure for the EmpInfo application must appear as follows:
Figure 5-25 shows the Project Explorer View.
128 Getting Started with Spring