HP Integrity NonStop J-Series - Manual (Page 140)

Changes to the Item.xml file
Before the change:
select qty as value from inventory where itemid = #value#
After the change:
select qty from inventory where itemid = #value#
dataAccessContext-local.xml
(<My SASH Home>\spring\samples\jpetstore\src\main\webapp\WEB-INF\
dataAccessContext-local.xml)
The dataAccessContext-local.xml file contains all the configuration metadata for JPetStore.
The bean with the dataSource ID in the dataAccessContext-local.xml file was modified to
use the customized SetDatabase class instead of the BasicDataSource class.
Changes to the dataAccessContext-local.xml file
Before the change:
After the change:
jdbc.properties
(<My SASH
Home>\spring\samples\jpetstore\src\main\webapp\WEB-INF\jdbc.properties)
This is the configuration file for connecting to the SQL/MX database. This file was 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.
•
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
140 Customizing Sample Applications