java - SqlExceptionHelper:错误:语法错误(近似位置:“用户”)
问题描述
我正在尝试启动一个项目,但我遇到了错误。请找到我的以下代码。
在日志中,我将其视为错误:
2021-05-08 06:13:01.474 INFO 18080 --- [nio-8080-exec-2] c.e.demo.controller.UserController : Handling save users: UserDto(id=null, name=test_name, surname=iva, login=test_login, password=1234567890, email=email@gmail.com)
2021-05-08 06:13:01.529 WARN 18080 --- [nio-8080-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 42601
2021-05-08 06:13:01.529 ERROR 18080 --- [nio-8080-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : Error: syntax error (approximate position: "user")
Position: 13
2021-05-08 06:13:01.548 ERROR 18080 --- [nio-8080-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement] with root cause
我在Controller中使用以下方法保存:
@RestController
@RequestMapping("/users")
@Log
@AllArgsConstructor
@Data
public class UserController {
private final UserService userService;
@PostMapping("/save")
public UserDto saveUsers(@RequestBody UserDto usersDto) throws ValidationException {
log.info("Handling save users: " + usersDto);
return userService.saveUser(usersDto);
}
用户实体:
@Entity
@Table(name = "user")
@Data
@NoArgsConstructo
@AllArgsConstructor
@Builder
public class User {
@Id
@SequenceGenerator(name = "user_id_seq", sequenceName = "user_id_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "user_id_seq")
private Integer id;
@Column(name = "name")
private String name;
@Column(name = "surname")
private String surname;
@Column(name = "login")
private String login;
@Column (name = "password")
private String password;
@Column (name = "email")
private String email;
}
我的错误是什么?
解决方案
推荐阅读
- python - Why does plotting combined Pandas data in Seaborn give "TypeError: -0.8 is not a string"?
- mysql - Order by case and number
- javascript - 你能从 xml 请求中返回一个数组吗?
- swift - 具有数组成员的结构的可编码合成不起作用?
- python - 在 Keras 模型中加载时出现 TypeError
- python - 使用 Anaconda 在 Google App Engine 上安装软件包?
- amazon-web-services - 无法在 EBS 上设置 Promethues 监控的 Kubernetes 指标持久存储
- dns - AXFR > BIND 区域转移
- javascript - 尝试连接 wsdl 服务时出错
- swift - tvOS 中的“AVFocusProxyView”是什么?得到一个奇怪的焦点问题