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

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://<HP NonStop System IP Address>:<Port No.>
#jdbc.username=<HP NonStop Username>
#jdbc.password=<HP NonStop Password>
#jdbc.catalog=jpetstorecat
#jdbc.schema=jpetstoresch
#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
(<My SASH Home>\spring\samples\jpetstore\src\main\java\org\
springframework\samples\jpetstore\dao\ibatis\maps\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>
Pom.xml
(<My SASH Home>\spring\samples\jpetstore\Pom.xml)
Pom.xml is a Maven file and is used to build the JPetStore application.
Customizing JPetStore 141