Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

db2 使用select ... for update语句出错 #1322

Closed
hualunqun opened this issue Jul 7, 2016 · 1 comment
Closed

db2 使用select ... for update语句出错 #1322

hualunqun opened this issue Jul 7, 2016 · 1 comment
Milestone

Comments

@hualunqun
Copy link

hualunqun commented Jul 7, 2016

项目使用了Quartz 2.2.1,并使用了数据库的方式,在项目启动时,quartz的schedulerFactory自动向数据库发出如下语句:
SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'schedulerFactory' AND LOCK_NAME = ? FOR UPDATE
druid(版本是1.0.21)打印的错误(只是打印,没有throw)为:

merge sql error :...com.alibaba.druid.sql.parser,ParserException: syntax error, expect READ, actual UPDATE

不知道这个问题有没有解决办法?谢谢。
补充:上面报错的SQL语句本地测试DB2支持。

wenshao added a commit to wenshao/druid that referenced this issue Jul 8, 2016
@wenshao wenshao modified the milestones: 1.0.22, 1.0.21 Jul 8, 2016
@wenshao wenshao closed this as completed Jul 9, 2016
@hualunqun
Copy link
Author

十分感谢,反应真快啊!!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants