Setting up jpetstore database on nonstop – HP Integrity NonStop H-Series User Manual
Page 55
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://
jdbc.username=
jdbc.password=
jdbc.catalog=jpetstorecat
jdbc.schema=jpetstoresch
4.
Build the JPetStore
WAR
file (
jpetstore.war
).
1.
Go to the
directory from the
command prompt using the command:
Command Prompt> cd
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
\
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