Manual

2. Modify the jdbc.properties file to update the JDBC configuration. You can use
either the JDBC/MX Type 2 driver or the JDBC/MX Type 4 driver. The SQL/MX settings
for each of them is as follows.
• If you plan to use the JDBC/MX Type 2 driver, uncomment the SQL/MX settings
for the JDBC Type 2 driver in the jdbc.properties file, so that the SQL/MX
settings for the JDBC Type 2 driver appear as:
#-------------------------------------------------------------
# SQL/MX Settings for JDBC Type 2 Driver
jdbc.driverClassName=com.tandem.sqlmx.SQLMXDriver
jdbc.url=jdbc:sqlmx://
jdbc.username=
jdbc.password=
jdbc.catalog=jpetstorecat
jdbc.schema=jpetstoresch
NOTE: Because the JDBC Type 2 driver resides on the NonStop system, you need
not mention the username and password in the jdbc.username and
jdbc.password fields.
• If you plan to use the JDBC/MX Type 4 driver, uncomment the SQL/MX settings
for JDBC Type 4 driver in the jdbc.properties file and enter the values of the
JDBC URL (NonStop system IP Address and port number of JDBC data source),
NonStop system username, and password. The SQL/MX settings for JDBC Type 4
driver in the jdbc.properties file appear as:
#-------------------------------------------------------------
# SQL/MX Settings for JDBC Type 4 Driver
jdbc.driverClassName= com.tandem.t4jdbc.SQLMXDriver
jdbc.url= jdbc:t4sqlmx://<HP NonStop System IP Address>:<Port No.>
jdbc.username=<HP NonStop Username>
jdbc.password=<HP NonStop Password>
jdbc.catalog=jpetstorecat
jdbc.schema=jpetstoresch
4. Build the JPetStore WAR file (jpetstore.war).
1. Go to the <My SASH Home>\spring\samples\jpetstore directory from the
command prompt using the command:
Command Prompt> cd <My SASH Home>\spring\samples\jpetstore
2. Build the JPetStore web archive.
• If you plan to use JDBC Type 2 driver, build the JPetStore web archive using the
command:
Command Prompt> ant –buildfile build_jdbct2.xml all
• If you plan to use JDBC Type 4 driver, build the JPetStore web archive using the
command:
Command Prompt> ant –buildfile build_jdbct4.xml all
After successful build, a new directory named dist is created in the <My SASH Home>\spring\
samples\jpetstore directory. The application WAR file (jpetstore.war) is created in the
dist directory on your Windows system.
Setting up JPetStore Database on NonStop
To set up the JPetStore database on your NonStop system, complete the following steps:
Deploying and Running Sample Spring Applications on NonStop 55