Jdbc.properties – HP Integrity NonStop H-Series User Manual
Page 155
>
jdbc.properties
(<
Spring Home>\samples\petclinic\src\jdbc.properties
)
This configuration file is used for connecting to the SQL/MX database and was modified to add
the SQL/MX JDBC properties instead of 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 out.
•
The
SQL/MX Settings
section that includes the JDBC Type 2 and Type 4 driver 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
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
….
…..
…..
….
#-------------------------------------------------------------------------------
# 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://
#jdbc.username=
#jdbc.password=
#jdbc.catalog=petcliniccat
#jdbc.schema=petclinicsch
#hibernate.dialect=org.hibernate.dialect.SqlmxDialect
#For JDBC Type 4 Driver:
#
Customizing PetClinic
155