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

destroy-method="close">
After the change:
destroy-method="close">
jdbc.properties
(\samples\jpetstore\war\WEB-INF\jdbc.properties):
This is the configuration file for connecting to the SQL/MX database. This file is modified to add
the SQL/MX JDBC properties instead of the default HSQL JDBC properties used by JPetStore.
Changes to the jdbc.properties file
The following modifications were made to set the JDBC properties for the SQL/MX database:
• The HSQL Settings section that includes the JDBC properties and the HSQL dialect file name
was commented out.
• The SQL/MX Settings section that includes the JDBC Type 2 and Type 4 drivers was added.
Before the change:
# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "dataAccessContext-local.xml".
# Targeted at system administrators, to avoid touching the context XML files.
jdbc.driverClassName=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost:9002
jdbc.username=sa
jdbc.password=
After the change:
# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "dataAccessContext-local.xml".
# Targeted at system administrators, to avoid touching the context XML files.
#jdbc.driverClassName=org.hsqldb.jdbcDriver
#jdbc.url=jdbc:hsqldb:hsql://localhost:9002
#jdbc.username=sa
#jdbc.password=
#-------------------------------------------------------------------------------
# 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
#-------------------------------------------------------------------------------
# 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
Customizing JPetStore 159