User Manual

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 JDBC Type 4 Dependency JAR File
Source LocationDependency JAR File
<JDBC T4 Installation Directory>\libt4sqlmx.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 “Adding Dependency JAR Files
in the Project Library Path” (page 89).
Creating Database Catalog, Schema, and Tables on NonStop
This section describes the steps to create the database catalog, schema, and tables on the 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 “EmpInfo Database Script” (page 134).
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 <NonStop SASH Home>/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
the 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.
The project directory structure for the EmpInfo application must appear as follows:
Overview of EmpInfo 113