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

3. Modify the jdbc.properties file based on the JDBC driver type you plan to use:
• If you plan to use the JDBC Type 2 driver, the SQL/MX settings for JDBC Type 2 driver
in the
jdbc.properties file must appear as:
#----------------------------------------------------------------------------
# SQL/MX Settings for JDBC Type 2 Driver
jdbc.url=jdbc:sqlmx://
jdbc.driver=com.tandem.sqlmx.SQLMXDriver
jdbc.user=
jdbc.password=
jdbc.catalog=empinfocat
jdbc.schema=empinfosch
NOTE: Because JDBC Type 2 driver resides on the NonStop system, you need not
enter the username and password in the jdbc.username and jdbc.password fields.
• If you plan to use the JDBC Type 4 driver, the SQL/MX settings for JDBC Type 4 driver
in the
jdbc.properties file must appear as:
#----------------------------------------------------------------------------
# SQL/MX Settings for JDBC Type 4 Driver
jdbc.driver=com.tandem.t4jdbc.SQLMXDriver
jdbc.url=jdbc:t4sqlmx://:
jdbc.user=
jdbc.password=
jdbc.catalog=empinfocat
jdbc.schema=empinfosch
NOTE:
— If you are using the JDBC Type 4 driver, enter the JDBC URL (NonStop system IP
Address and Port Number of the JDBC data source), NonStop system username,
and password.
— The name of the database catalog used in the example is empinfocat and the
schema name is 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 names in the
jdbc.properties file.
Modifying the EmpInfo-servlet.xml File
Modify the EmpInfo-servlet.xml file in the EmpInfo/WebContent/WEB-INF directory to
define the new form and controller as shown below:
NOTE: By default, XML files open in the XML Editor. The XML Editor has two views: Design
and Source view. Select the Source view.
Before modification:
After modification:
insert
com.hp.empinfo.domain.Employee
emp
After modification, the EmpInfo-servlet.xml file appears as:
124 Getting Started with Spring