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

当数据库列中使用了ORACLE数据库关键字Exception时报错 #1211

Closed
mfkvfn opened this issue May 6, 2016 · 3 comments
Closed
Milestone

Comments

@mfkvfn
Copy link

mfkvfn commented May 6, 2016

为了记录异常信息到Oracle数据库日志表中,sql为
insert into sys_log(ID,EXCEPTION) values(?,?)
会报错。原因是druid中认为EXCEPTION是oracle关键字。改成
insert into sys_log(ID,"EXCEPTION") values(?,?)
也不行。

不用druid的话以上2条语句都能正常执行,用了druid都无法执行。

注:ID为char(32)类型,EXCEPTION为CLOB。

@mfkvfn mfkvfn changed the title 当数据库列中使用了数据库关键字Exception时报错 当数据库列中使用了ORACLE数据库关键字Exception时报错 May 6, 2016
@wenshao
Copy link
Member

wenshao commented May 6, 2016

你在filters上配置了wall(SQL防火墙)?

wenshao added a commit to wenshao/druid that referenced this issue May 6, 2016
@wenshao wenshao added this to the 1.0.19 milestone May 6, 2016
@wenshao
Copy link
Member

wenshao commented May 6, 2016

如果没有配置filters="wall",那样只会打印error log。同时我也修正了此问题,等过几天发布新版本吧

@wenshao wenshao closed this as completed May 6, 2016
@mfkvfn
Copy link
Author

mfkvfn commented May 8, 2016

filters只配置了config,stat。已自己下载并编译mater代码,测试通过,期待新版本。
另外,你们响应issue速度很快。赞一个。

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