无法在springMVC中执行语句

Question

这是我的类

package com.ducnd.pojo;

/**
*
* @author DucND
*/
@Entity
@Table(name = "group")
@XmlRootElement
@NamedQueries({
@NamedQuery(name = "Group1.findAll", query = "SELECT g FROM Group1 g"),
@NamedQuery(name = "Group1.findById", query = "SELECT g FROM Group1 g WHERE g.id = :id"),
@NamedQuery(name = "Group1.findByGroupname", query = "SELECT g FROM Group1 g WHERE g.groupname = :groupname"),
@NamedQuery(name = "Group1.findByPurpose", query = "SELECT g FROM Group1 g WHERE g.purpose = :purpose")})
public class Group1 implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@NotNull
@Column(name = "id")
private Integer id;
@Size(max = 45)
@Column(name = "groupname")
private String groupname;
@Size(max = 45)
@Column(name = "purpose")
private String purpose;
@JoinTable(name = "user_group", joinColumns = {
@JoinColumn(name = "group_id", referencedColumnName = "id")}, inverseJoinColumns = {
@JoinColumn(name = "user_id", referencedColumnName = "id")})
@ManyToMany
private Collection<User> userCollection;
@OneToMany(cascade = CascadeType.ALL, mappedBy = "group1")
private Collection<UserSpendingGroup> userSpendingGroupCollection;
@OneToMany(cascade = CascadeType.ALL, mappedBy = "group1")
private Collection<UserIncomeGroup> userIncomeGroupCollection;
@JoinColumn(name = "user_id", referencedColumnName = "id")
@ManyToOne
private User userId;

这是我调用创建组服务的地方

@Controller
@ControllerAdvice
public class GroupController {

@Autowired
private GroupService groupService;


@GetMapping("/create-group")
public String createGroup(Model model){

model.addAttribute("group", new Group1());

return "createGroup";
}

@PostMapping("/create-group")
public String createGroup(Model model, @ModelAttribute(value = "group")Group1 group, HttpSession session){
User currentUser = (User) session.getAttribute("currentUser");
group.setId(3);
group.setUserId(currentUser);

if(this.groupService.createGroup(group)==true){
return "redirect:/";
}
return "createGroup";
}


}

这是我得到的错误

org.springframework.web.util.NestedServlet异常：请求处理失败；嵌套异常为org.springframework.dao.InvalidDataAccessResourceUsageException：无法执行语句；SQL[n/a]；嵌套异常为org.hubinate.exception.SQLGrammaException：无法执行语句

请有人帮我解决这个问题

Answer 1

要知道group是SQL中的一个关键字。尝试将其更改为其他内容或使用反勾号。