Jdbc.properties – HP Integrity NonStop H-Series User Manual
Page 163
<property name="startDelay" value="3600000"/>
<property name="repeatInterval" value="3600000"/>
</bean>
•
Increased the time interval for which the application invokes the
checkImages
method in
the
org.springframework.samples.imagedb.DefaultImageDatabase
class.
Before the change :
<bean id="checkImagesTrigger"
class="org.springframework.scheduling.quartz.CronTriggerBean">
<property name="jobDetail" ref="checkImagesJobDetail"/>
<property name="cronExpression" value="0/5 * * * * ?"/>
</bean>
After the change:
<bean id="checkImagesTrigger"
class="org.springframework.scheduling.quartz.CronTriggerBean">
<property name="jobDetail" ref="checkImagesJobDetail"/>
<property name="cronExpression" value="0 0 */1 * * ? *"/>
</bean>
jdbc.properties
(<Spring Home>\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