JPA 注解生成表问题，已解决

最新推荐文章于 2024-09-03 11:08:15 发布

优秀的小白

最新推荐文章于 2024-09-03 11:08:15 发布

阅读量772

点赞数

本文链接：https://blog.csdn.net/qq_35609376/article/details/105080877

版权

博客主要讲述了在使用JPA时遇到的SQL语法错误，由于在主键的@Column注解中错误地设置了unique=true，导致Druid解析SQL时抛出异常。解决方案是移除unique参数，因为主键默认就是唯一的。

摘要由CSDN通过智能技术生成

java.sql.SQLException: sql injection violation, syntax error, expect RPAREN, actual UNIQUE unique,问题已解决

报错信息
报错原因
解决方法

报错信息

java.sql.SQLException: sql injection violation, syntax error, expect RPAREN, actual UNIQUE unique,
Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, expect RPAREN, actual UNIQUE unique

2020-03-24 19:30:09 com.alibaba.druid.filter.logging.Log4jFilter.statementLogError(Log4jFilter.java:152) ERROR: {conn-10001, stmt-20000} execute error. create table bss_sensitive_command (cmd_id varchar(32) not null unique, cmd_name varchar(50) not null, command varchar(500) not null, description varchar(100), is_regular varchar(32) not null, status varchar(1) not null, primary key (cmd_id))
java.sql.SQLException: sql injection violation, syntax error, expect RPAREN, actual UNIQUE unique, pos 70 : create table bss_sensitive_command (cmd_id varchar(32) not null unique, cmd_name varchar(50) not null, command varchar(500) not null, description varchar(100), is_regular varchar(32) not null, status varchar(1) not null, primary key (cmd_id))
at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:592)
at com.alibaba.druid.wall.WallFilter.statement_executeUpdate(WallFilter.java:432)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2373)
at com.alibaba.druid.filter.FilterAdapter.statement_executeUpdate(FilterAdapter.java:2486)
at com.alibaba.druid.filter.FilterEventAdapter.statement_executeUpdate(FilterEventAdapter.java:327)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2373)
at com.alibaba.druid.filter.FilterAdapter.statement_executeUpdate(FilterAdapter.java:2486)
at com.alibaba.druid.filter.FilterEventAdapter.statement_executeUpdate(FilterEventAdapter.java:327)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2373)
at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeUpdate(StatementProxyImpl.java:225)
at com.alibaba.druid.pool.DruidPooledStatement.executeUpdate(DruidPooledStatement.java:169)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:227)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:503)
at org.hibernate.cfg.Conf