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

jdbc.properties
(<My SASH Home>\spring\samples\petclinic\src\main\resources\
jdbc.properties
)
This configuration file is used for connecting to the SQL/MX database, and was modified to add
the SQL/MX JDBC properties to override the default HSQL JDBC properties used by PetClinic.
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:
#-------------------------------------------------------------------------------
# HSQL Settings
jdbc.driverClassName=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost:9001
jdbc.username=sa
jdbc.password=
# Property that determines which Hibernate dialect to use
# (only applied with "applicationContext-hibernate.xml")
hibernate.dialect=org.hibernate.dialect.HSQLDialect
# Property that determines which database to use with an AbstractJpaVendorAdapter#
jpa.database=HSQL
After the change:
#-------------------------------------------------------------------------------
# HSQL Settings
#jdbc.driverClassName=org.hsqldb.jdbcDriver
#jdbc.url=jdbc:hsqldb:hsql://localhost:9001
#jdbc.username=sa
#jdbc.password=
# Property that determines which Hibernate dialect to use
# (only applied with "applicationContext-hibernate.xml")
#hibernate.dialect=org.hibernate.dialect.HSQLDialect
# Property that determines which database to use with an AbstractJpaVendorAdapter
# jpa.database=HSQL
….
…..
…..
….
#-------------------------------------------------------------------------------
# SQL/MX Settings for JDBC Type 2 Driver
#jdbc.driverClassName=com.tandem.sqlmx.SQLMXDriver
#jdbc.url=jdbc:sqlmx://
#jdbc.username=
#jdbc.password=
#jdbc.catalog=petcliniccat
#jdbc.schema=petclinicsch
#hibernate.dialect=org.hibernate.dialect.SqlmxDialect
#-------------------------------------------------------------------------------
# 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=petcliniccat
#jdbc.schema=petclinicsch
#hibernate.dialect=org.hibernate.dialect.SqlmxDialect
#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
138 Customizing Sample Applications