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.

Sign up for GitHub

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

Jump to bottom

com.alibaba:druid:1.0.16 dbType not support : sqlite #992

Closed
ZhanPeng opened this issue Nov 16, 2015 · 2 comments
Closed

com.alibaba:druid:1.0.16 dbType not support : sqlite #992

ZhanPeng opened this issue Nov 16, 2015 · 2 comments

Comments

@ZhanPeng
Copy link

druid 1.0.16 dbType not support : sqlite
@mfkvfn
Copy link

mfkvfn commented Jul 6, 2016 •
edited

我也遇到这个问题。PageUtils.java中limit只支持了Oracle,DB2,SQL_SERVER，MYSQL，MARIADB，H2，POSTGRESQL。其它的数据库会抛出UnsupportedOperationException。实际上sqlite跟mysql的limit语句一样。我的解决办法是“虽然你用的sqlite，但是要limit时dbType传入mysql即可”。感觉不是很完美。
另外sqlite数据库用PageUtils.java中的生成limit语句的方法生成语句后，如果filter中配置了stat，statFilter会认为它刚刚生成的分页语句的语法有错误。我实在没办法，只能把stat这个filter去掉了。

@lizongbo
Copy link
Collaborator

请使用最新版验证

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lizongbo @ZhanPeng @mfkvfn