Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 17th, 2012  |  syntax: None  |  size: 7.21 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Does Quartz Scheduler work with DB2 9.7?
  2. org.quartz.threadPool.class = org.quartz.simpl.SimpleThreadPool
  3.  
  4. org.quartz.threadPool.threadCount = 10
  5.  
  6. org.quartz.threadPool.threadPriority = 5
  7. org.quartz.threadPool.threadsInheritContextClassLoaderOfInitializingThread = true
  8.        
  9. # Using JobStoreTX
  10. ## Be sure to run the appropriate script(under docs/dbTables) first to create tables
  11.     org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
  12.  
  13. # Configuring JDBCJobStore with the Table Prefix
  14.     org.quartz.jobStore.tablePrefix = QRTZ_
  15.  
  16. # Using DriverDelegate
  17.     org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.DB2v8Delegate
  18.  
  19. # Using datasource
  20.     org.quartz.jobStore.dataSource = qzDS
  21.  
  22. # Define the datasource to use
  23.     org.quartz.dataSource.qzDS.driver = com.ibm.db2.jcc.DB2Driver
  24.  
  25.     org.quartz.dataSource.qzDS.URL = jdbc:db2://localhost:50000/sample
  26.  
  27.     org.quartz.dataSource.qzDS.user = *****
  28.  
  29.     org.quartz.dataSource.qzDS.password = *****
  30.  
  31.     org.quartz.dataSource.qzDS.maxConnections = 30
  32.        
  33. create table qrtz_job_details (
  34. job_name varchar(80) not null,
  35. job_group varchar(80) not null,
  36. description varchar(120),
  37. job_class_name varchar(128) not null,
  38. is_durable varchar(1) not null,
  39. is_volatile varchar(1) not null,
  40. is_stateful varchar(1) not null,
  41. requests_recovery varchar(1) not null,
  42. job_data blob(2000),
  43. primary key (job_name,job_group)
  44. );
  45.  
  46. create table qrtz_job_listeners(
  47. job_name varchar(80) not null,
  48. job_group varchar(80) not null,
  49. job_listener varchar(80) not null,
  50. primary key (job_name,job_group,job_listener),
  51. foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
  52. );
  53.  
  54. create table qrtz_triggers(
  55. trigger_name varchar(80) not null,
  56. trigger_group varchar(80) not null,
  57. job_name varchar(80) not null,
  58. job_group varchar(80) not null,
  59. is_volatile varchar(1) not null,
  60. description varchar(120),
  61. next_fire_time bigint,
  62. prev_fire_time bigint,
  63. trigger_state varchar(16) not null,
  64. trigger_type varchar(8) not null,
  65. start_time bigint not null,
  66. end_time bigint,
  67. calendar_name varchar(80),
  68. misfire_instr smallint,
  69. primary key (trigger_name,trigger_group),
  70. foreign key (job_name,job_group) references qrtz_job_details(job_name,job_group)
  71. );
  72.  
  73. create table qrtz_simple_triggers(
  74. trigger_name varchar(80) not null,
  75. trigger_group varchar(80) not null,
  76. repeat_count bigint not null,
  77. repeat_interval bigint not null,
  78. times_triggered bigint not null,
  79. primary key (trigger_name,trigger_group),
  80. foreign key (trigger_name,trigger_group) references        
  81. qrtz_triggers(trigger_name,trigger_group)
  82. );
  83.  
  84. create table qrtz_cron_triggers(
  85. trigger_name varchar(80) not null,
  86. trigger_group varchar(80) not null,
  87. cron_expression varchar(80) not null,
  88. time_zone_id varchar(80),
  89. primary key (trigger_name,trigger_group),
  90. foreign key (trigger_name,trigger_group) references        
  91. qrtz_triggers(trigger_name,trigger_group)
  92. );
  93.  
  94. create table qrtz_blob_triggers(
  95. trigger_name varchar(80) not null,
  96. trigger_group varchar(80) not null,
  97. blob_data blob(2000),
  98. primary key (trigger_name,trigger_group),
  99. foreign key (trigger_name,trigger_group) references    
  100. qrtz_triggers(trigger_name,trigger_group)
  101. );
  102.  
  103. create table qrtz_trigger_listeners(
  104. trigger_name varchar(80) not null,
  105. trigger_group varchar(80) not null,
  106. trigger_listener varchar(80) not null,
  107. primary key (trigger_name,trigger_group,trigger_listener),
  108. foreign key (trigger_name,trigger_group) references
  109. qrtz_triggers(trigger_name,trigger_group)
  110. );
  111.  
  112. create table qrtz_calendars(
  113. calendar_name varchar(80) not null,
  114. calendar blob(2000) not null,
  115. primary key (calendar_name)
  116. );
  117.  
  118. create table qrtz_fired_triggers(
  119. entry_id varchar(95) not null,
  120. trigger_name varchar(80) not null,
  121. trigger_group varchar(80) not null,
  122. is_volatile varchar(1) not null,
  123. instance_name varchar(80) not null,
  124. fired_time bigint not null,
  125. state varchar(16) not null,
  126. job_name varchar(80),
  127. job_group varchar(80),
  128. is_stateful varchar(1),
  129. requests_recovery varchar(1),
  130. primary key (entry_id)
  131. );
  132.  
  133.  
  134. create table qrtz_paused_trigger_grps(
  135. trigger_group varchar(80) not null,
  136. primary key (trigger_group)
  137. );
  138.  
  139. create table qrtz_scheduler_state (
  140. instance_name varchar(80) not null,
  141. last_checkin_time bigint not null,
  142. checkin_interval bigint not null,
  143. recoverer varchar(80),
  144. primary key (instance_name)
  145. );
  146.  
  147. create table qrtz_locks
  148. (
  149. lock_name varchar(40) not null,
  150. primary key (lock_name)
  151. );
  152.  
  153. insert into qrtz_locks values('TRIGGER_ACCESS');
  154. insert into qrtz_locks values('JOB_ACCESS');
  155. insert into qrtz_locks values('CALENDAR_ACCESS');
  156. insert into qrtz_locks values('STATE_ACCESS');
  157. insert into qrtz_locks values('MISFIRE_ACCESS');
  158.        
  159. org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't recover jobs: DB2 SQL Error:     SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75 [See nested exception:     com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703,     SQLERRMC=SCHED_NAME, DRIVER=3.63.75]]
  160. at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:683)
  161. at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:526)
  162. at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
  163. at ScheduleManager.main(ScheduleManager.java:20)
  164. Caused by: org.quartz.JobPersistenceException: Couldn't recover jobs: DB2 SQL Error:     SQLCODE=-206, SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75 [See nested exception:     com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703,     SQLERRMC=SCHED_NAME, DRIVER=3.63.75]
  165. at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:889)
  166. at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.execute(JobStoreSupport.java:827)
  167. at org.quartz.impl.jdbcjobstore.JobStoreSupport$46.execute(JobStoreSupport.java:3776)
  168. at         org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java    :3810)
  169. at     org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java    :3772)
  170. at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:823)
  171. at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:681)
  172. ... 3 more
  173. Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206,        SQLSTATE=42703, SQLERRMC=SCHED_NAME, DRIVER=3.63.75
  174. at com.ibm.db2.jcc.am.fd.a(fd.java:679)
  175. at com.ibm.db2.jcc.am.fd.a(fd.java:60)
  176. at com.ibm.db2.jcc.am.fd.a(fd.java:127)
  177. at com.ibm.db2.jcc.am.yn.c(yn.java:2644)
  178. at com.ibm.db2.jcc.am.yn.d(yn.java:2632)
  179. at com.ibm.db2.jcc.am.yn.a(yn.java:2097)
  180. at com.ibm.db2.jcc.am.zn.a(zn.java:7197)
  181. at com.ibm.db2.jcc.t4.cb.h(cb.java:141)
  182. at com.ibm.db2.jcc.t4.cb.b(cb.java:41)
  183. at com.ibm.db2.jcc.t4.q.a(q.java:32)
  184. at com.ibm.db2.jcc.t4.sb.i(sb.java:135)
  185. at com.ibm.db2.jcc.am.yn.gb(yn.java:2066)
  186. at com.ibm.db2.jcc.am.zn.pc(zn.java:3446)
  187. at com.ibm.db2.jcc.am.zn.b(zn.java:4236)
  188. at com.ibm.db2.jcc.am.zn.dc(zn.java:757)
  189. at com.ibm.db2.jcc.am.zn.executeUpdate(zn.java:740)
  190. at       com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.    java:105)
  191. at         org.quartz.impl.jdbcjobstore.StdJDBCDelegate.updateTriggerStatesFromOtherStates(StdJDBCDele    gate.java:259)
  192. at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:844)
create a new version of this paste RAW Paste Data