首页 / JAVA / mysql报错：Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 39, line 2,

mysql报错：Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 39, line 2,

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql报错：Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 39, line 2,，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1504字，纯文字阅读大概需要3分钟。

内容图文

 

因为close是mysql关键字

2019-11-07 21:33:33,963 DEBUG (BaseJdbcLogger.java:159)- ==>  Preparing: select 'true' as QUERYID, id, posid, userid, account_id, contract, open, close, size, deal_size, limitt, stop, status, ctime, utime, direction, type, stop_mode, trailing_step, price_level, cancel_date, fee_buy, fee_sell, routing_status, settle_asset from exproto_contract_position order by id DESC limit 0, 15 
2019-11-07 21:33:33,968 INFO (XmlBeanDefinitionReader.java:316)- Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2019-11-07 21:33:34,002 ERROR (CommonUtils.java:182)- msg:runtimeExceptionHandler: org.springframework.jdbc.UncategorizedSQLException: 
### Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 98, line 5, column 52, token CLOSE :
select  
    'true' as QUERYID,
    id, posid, userid, account_id, contract, open, close, size, deal_size, limitt, stop, 
    status, ctime, utime, direction, type, stop_mode, trailing_step, price_level, cancel_date, 
    fee_buy, fee_sell, routing_status, settle_asset
    from exproto_contract_position
    order by id DESC
    limit 0, 15
### The error may exist in file [D:\oy\new_gitRepository\exchangeapi\jweb-dao\target\classes\amberai\jweb\mapping\ContractPositionMapper.xml]
### The error may involve amberai.jweb.dao.ContractPositionDao.selectByExample
### The error occurred while executing a query

 

参考：https://blog.csdn.net/duantianya2012/article/details/54571386

内容总结

以上是互联网集市为您收集整理的mysql报错：Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 39, line 2,全部内容，希望文章能够帮你解决mysql报错：Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. pos 39, line 2,所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/882690.html

来源：【匿名】