Manual

#For JDBC Type 4 Driver:
#
#<HP NonStop System IP Address> - This is the IP address of your NonStop system
#<Port No.> - This is the Port Number of JDBC Data Source
#<HP NonStop Username> - This is the HP NonStop system UserName
#<HP NonStop Password> - This is the HP NonStop system Password
Order.xml
(<Spring Home>\jpetstore\src\org\springframework\samples\jpetstore\dao\
ibatis\Order.xml):
Order.xml is the ibatis mapping file that maps the Order.java class to the order table. In
SQL/MX database, 'timestamp' is a keyword; therefore, the insert query for orderstatus in
the order.xml file was modified.
Changes to the Order.xml file
Before the change:
<insert id="insertOrderStatus">
insert into orderstatus (ordered , linenum , timestamp , status)
values (#orderId#, #orderId#, #orderDate#, #status#)
</insert>
After the change:
<insert id="insertOrderStatus">
insert into orderstatus (orderid, linenum, "timestamp", status)
values (#orderId#, #orderId#, #orderDate#, #status#)
</insert>
Customizing ImageDB
To customize the ImageDB sample application to run on NonStop systems, the following eight
files were modified:
• build_jdbct2.xml
• build_jdbct4.xml
• applicationContext.xml
• schedulingContext-quartz.xml
• jdbc.properties
• ImageController.java
• ImageDatabase.java
• DefaultImageDatabase.java
Modified Files
The following files were modified to customize ImageDB:
build_jdbct2.xml
(<Spring Home>\samples\imagedb\build_jdbct2.xml)
This is the build file for ImageDB when using the JDBC Type 2 driver for database connectivity.
The build_jdbct2.xml file is modified to update the Spring Root Location (property:
spring.root).
160 Customizing Sample Applications