showcase的初始化时是不是少一张表？

Question

启动报错

Caused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Table "QRTZ_TRIGGERS" not found; SQL statement:

SELECT * FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'clusterQuartzScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [42102-164] [See nested exception: org.h2.jdbc.JdbcSQLException: Table "QRTZ_TRIGGERS" not found; SQL statement:

SELECT * FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'clusterQuartzScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [42102-164]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)

at org.h2.message.DbException.get(DbException.java:169)

at org.h2.message.DbException.get(DbException.java:146)

at org.h2.command.Parser.readTableOrView(Parser.java:4753)

at org.h2.command.Parser.readTableFilter(Parser.java:1080)

at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1686)

at org.h2.command.Parser.parseSelectSimple(Parser.java:1793)

at org.h2.command.Parser.parseSelectSub(Parser.java:1680)

at org.h2.command.Parser.parseSelectUnion(Parser.java:1523)

at org.h2.command.Parser.parseSelect(Parser.java:1511)

at org.h2.command.Parser.parsePrepared(Parser.java:405)

at org.h2.command.Parser.parse(Parser.java:279)

at org.h2.command.Parser.parse(Parser.java:251)

at org.h2.command.Parser.prepareCommand(Parser.java:217)

at org.h2.engine.Session.prepareLocal(Session.java:415)

at org.h2.server.TcpServerThread.process(TcpServerThread.java:250)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:146)

at java.lang.Thread.run(Thread.java:619)

]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1524)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$12.execute(JobStoreSupport.java:1512)

at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3715)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1509)

at org.quartz.core.QuartzScheduler.getTrigger(QuartzScheduler.java:1476)

at org.quartz.impl.StdScheduler.getTrigger(StdScheduler.java:499)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:191)

... 31 more

Caused by: org.h2.jdbc.JdbcSQLException: Table "QRTZ_TRIGGERS" not found; SQL statement:

SELECT * FROM QRTZ_TRIGGERS WHERE SCHED_NAME = 'clusterQuartzScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [42102-164]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)

at org.h2.message.DbException.get(DbException.java:169)

at org.h2.message.DbException.get(DbException.java:146)

at org.h2.command.Parser.readTableOrView(Parser.java:4753)

at org.h2.command.Parser.readTableFilter(Parser.java:1080)

at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1686)

at org.h2.command.Parser.parseSelectSimple(Parser.java:1793)

at org.h2.command.Parser.parseSelectSub(Parser.java:1680)

at org.h2.command.Parser.parseSelectUnion(Parser.java:1523)

at org.h2.command.Parser.parseSelect(Parser.java:1511)

at org.h2.command.Parser.parsePrepared(Parser.java:405)

at org.h2.command.Parser.parse(Parser.java:279)

at org.h2.command.Parser.parse(Parser.java:251)

at org.h2.command.Parser.prepareCommand(Parser.java:217)

at org.h2.engine.Session.prepareLocal(Session.java:415)

at org.h2.server.TcpServerThread.process(TcpServerThread.java:250)

at org.h2.server.TcpServerThread.run(TcpServerThread.java:146)

at java.lang.Thread.run(Thread.java:619)

 

at org.h2.engine.SessionRemote.done(SessionRemote.java:565)

at org.h2.command.CommandRemote.prepare(CommandRemote.java:67)

at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)

at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:437)

at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1121)

at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)

at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:73)

at $Proxy92.prepareStatement(Unknown Source)

at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1741)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1520)

... 42 more

Answer 1

RC1版的确忘记了......SNAPSHOT版里面有。建议大家多点直接Pull代码，有了Jenkins后，现在代码质量还挺不错的。

Answer 2

在/showcase/pom.xml文件中，没有找到初始化quartz.sql的指令。

Answer 3

quickstart showcase是不行的 我是在application*.xml文件中把quartz相关servcie注解掉了，难道还需要手工执行
refreshdb.bat？

Answer 4

在文件examplesshowcasesrcmainresourcesapplication.properties中jdbc.url的数据源不同，执行sql语句时需要注意不同的数据源信息

Answer 5

sql examplesshowcasesrcmainresourcessqlh2quartz.sql 里是有这个QRTZ_TRIGGERS的哦，确定开着H2后，执行了那个refreshdb.bat了么？

Answer 6

我启动Jetty的时候也碰到了这个问题，我把 相关的sql examplesshowcasesrcmainresourcessqlh2quartz.sql

和

examplesshowcasesrcmainresourcessqlh2schema.sql

在h2上手的执行了下，启动Jetty的时候也还是碰到类似问题，看报错的信息好像是表没有，但查询H2的时候也有，不知是啥问题？