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

#For JDBC Type 4 Driver:
#
# - This is the IP address of your NonStop system
# - This is the Port Number of JDBC Data Source
# - This is the HP NonStop system UserName
# - This is the HP NonStop system Password
Order.xml
(>\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 into orderstatus (ordered , linenum , timestamp , status)
values (#orderId#, #orderId#, #orderDate#, #status#)
After the change:
insert into orderstatus (orderid, linenum, "timestamp", status)
values (#orderId#, #orderId#, #orderDate#, #status#)
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
(\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