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

• Increased the time interval for which the application invokes the checkImages method in
the org.springframework.samples.imagedb.DefaultImageDatabase class.
Before the change :
class="org.springframework.scheduling.quartz.CronTriggerBean">
After the change:
class="org.springframework.scheduling.quartz.CronTriggerBean">
jdbc.properties
(\samples\imagedb\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 MySQL JDBC properties used by ImageDB.
Changes to the jdbc.properties file
The following modifications were made to set the JDBC properties for the SQL/MX database:
1. The MySQL Settings section containing the JDBC properties was commented out.
2. The SQL/MX Settings section containing the JDBC properties was added.
Before the change:
# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "applicationContext.xml".
# Targeted at system administrators, to avoid touching the context XML files.
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/imagedb
jdbc.username=admin
jdbc.password=
imageDatabase.lobHandler=defaultLobHandler
#jdbc.driverClassName=oracle.jdbc.OracleDriver
#jdbc.url=jdbc:oracle:thin:@localhost:1521:imagedb
#jdbc.username=scott
#jdbc.password=tiger
#imageDatabase.lobHandler=oracleLobHandler
After the change:
# Properties file with JDBC-related settings.
….
….
….
#-------------------------------------------------------------------------------
#common settings
#
#imageDatabase.lobHandler=defaultLobHandler
#jdbc.blobTableName=imagedbcat.imagedbsch.blobTableName
#jdbc.catalog=imagedbcat
#jdbc.schema=imagedbsch
#-------------------------------------------------------------------------------
# SQL/MX Settings for JDBC Type 2 Driver
#jdbc.driverClassName=com.tandem.sqlmx.SQLMXDriver
Customizing ImageDB 163