Order.xml, Customizing imagedb, Modified files – HP Integrity NonStop H-Series User Manual
Page 160: Build_jdbct2.xml
#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:
•
•
•
•
•
•
•
•
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