quartz2.2.1bug

quartz2.1.5 调用 scheduler.start()方法时报这样一个异常： 
严重: An error occurred while scanning for the next triggers to fire. 
org.quartz.JobPersistenceException: Couldn't acquire next trigger: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=1' at line 1 [See nested exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=1' at line 1] ,

 

百度了半天都解决不了，最终修改了mysql驱动包，5.1.6-》5.1.44,启动成功，没有仔细去理解原理，之后还需要仔细看下