Hi!
I just got JI to work (well up and running war and database) on JBoss using HSQLDB and wanted to let everybody know about my mods...
I basically had to setup the right driver and connection strings and that got me most of the way. However there are problems with Quartz and HSQLDB. Row level locking with select... for update.. does not work. To fix the problem I had to insert
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate
org.quartz.jobStore.selectWithLockSQL=SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?
in js.quartz.properties
Hope that helps
manfred
I just got JI to work (well up and running war and database) on JBoss using HSQLDB and wanted to let everybody know about my mods...
I basically had to setup the right driver and connection strings and that got me most of the way. However there are problems with Quartz and HSQLDB. Row level locking with select... for update.. does not work. To fix the problem I had to insert
org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate
org.quartz.jobStore.selectWithLockSQL=SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ?
in js.quartz.properties
Hope that helps
manfred
0 Answers:
No answers yet
