org.hibernate.exception.DataException:无法执行语句

新手上路,请多包涵

我是 Spring 和 Hibernate 的新手,我正在开发电子商务管理系统,我的问题是使用 Hibernate 将文件上传到数据库中。我有一些服务,但我发现它不起作用。

这是我的代码

领域

@Entity
@Table(name = "DEPUTES_APPEAL")
public class DeputesAppeal implements Serializable {

@Id
@Column(name = "ID")
@GeneratedValue
private long id;

@Column(name = "NumberOfAppeal")
private Integer number;

@Column(name = "DateOfIncomingAppeal")
private Date IncomingDate;

@Column(name = "NameOfDepute")
private String NameOfDepute;

@Column(name = "ResolutionOfChief")
private String ResolutionOfChief;

@Column(name = "TypeOfAppeal")
private String typeOfAppeal;

@OneToMany(mappedBy = "deputesAppeal", cascade =
CascadeType.ALL, fetch= FetchType.EAGER)

private final Set<UploadFiles> fileUpload = new HashSet<UploadFiles>
();

public DeputesAppeal(){}

public DeputesAppeal(int id, int number, Date incomingDate, String
nameOfDepute, String resolutionOfChief) {
    this.id = id;
    this.number = number;
    this.IncomingDate = incomingDate;
    this.NameOfDepute = nameOfDepute;
    this.ResolutionOfChief = resolutionOfChief;
}

public long getId() {
    return id;
}

public Integer getNumber() {
    return number;
}

public void setNumber(Integer number) {
    this.number = number;
}

public Date getIncomingDate() {
    return IncomingDate;
}

public void setIncomingDate(Date incomingDate) {
    IncomingDate = incomingDate;
}

public String getNameOfDepute() {
    return NameOfDepute;
}

public void setNameOfDepute(String nameOfDepute) {
    NameOfDepute = nameOfDepute;
}

public String getResolutionOfChief() {
    return ResolutionOfChief;
}

public void setResolutionOfChief(String resolutionOfChief) {
    ResolutionOfChief = resolutionOfChief;
}

public String getTypeOfAppeal() {
    return typeOfAppeal;
}

public void setTypeOfAppeal(String typeOfAppeal) {
    this.typeOfAppeal = typeOfAppeal;
}

public Set<UploadFiles> getFileUpload() {
    return fileUpload;
}
}

我保存对象的 dao 层,其字段是 Set of UploadFiles

 public class MysqlImpl implements DeputesAppealDao{

@Autowired
SessionFactory sessionFactory;

public List<DeputesAppeal> getAll() {
    Query query = sessionFactory.getCurrentSession().createQuery("from
DeputesAppeal");
    return query.list();
}

public DeputesAppeal getById(Integer id) {
    DeputesAppeal deputesAppeal = (DeputesAppeal)
sessionFactory.getCurrentSession().get(DeputesAppeal.class, id);
    return deputesAppeal;
}

public void addAppeal(DeputesAppeal deputesAppeal,
CommonsMultipartFile[] fileUpload) {
    if (fileUpload != null && fileUpload.length > 0) {
        for (CommonsMultipartFile aFile : fileUpload) {
            UploadFiles uploadFiles = new UploadFiles();
            uploadFiles.setFileName(aFile.getOriginalFilename());
            uploadFiles.setData(aFile.getBytes());
            deputesAppeal.addFile(uploadFiles);
            sessionFactory.getCurrentSession().save(deputesAppeal);
        }
    }
}

public void deleteAppeal(Integer id) {
     DeputesAppeal deputesAppeal = (DeputesAppeal)
sessionFactory.getCurrentSession().get(DeputesAppeal.class, id);
     sessionFactory.getCurrentSession().delete(deputesAppeal);
}

public void editAppeal(DeputesAppeal deputesAppeal, DeputesAppeal
existingDeputesAppeal) {
     sessionFactory.getCurrentSession().save(existingDeputesAppeal);
}

public DeputesAppeal modSession(DeputesAppeal deputesAppeal) {
    DeputesAppeal deputesAppeal1 = (DeputesAppeal)
sessionFactory.getCurrentSession().get(DeputesAppeal.class,
deputesAppeal.getId());
    return  deputesAppeal1;
}

public List<DeputesAppeal> abstractSearch(String searchingChar) {
    Query query = sessionFactory.getCurrentSession().createQuery("from
DeputesAppeal where id = " + searchingChar);
    return query.list();
}

}

至少是 Controller

 @Controller
@RequestMapping(value = "/main")
public class MainController {

@Qualifier("deputesAppealServiceBean")
@Autowired
DeputesAppealService deputesAppealService;

@RequestMapping(value = "/mainFrame", method = RequestMethod.GET)
public String getMainPage(){
    return "mainPage";
}

@RequestMapping(value = "/resultOfSearching", method =
RequestMethod.GET)
public String getSearchResult(Model model,
@ModelAttribute("searchChar")String searchResult){
    List<DeputesAppeal> deputesAppeals =
deputesAppealService.abstractSearch(searchResult);
    model.addAttribute("ListOfAppeals", deputesAppeals);
    return "searchingResultPage";
}

@RequestMapping(value = "mainFrame/new", method = RequestMethod.GET)
public String getAddNewAppealPage(){
    return "addPage";
}

@RequestMapping(value = "mainFrame/new", method = RequestMethod.POST)
public String addNewAppeal(@ModelAttribute("Appeal")DeputesAppeal
deputesAppeal,

@RequestParam("fileUpload")CommonsMultipartFile[] fileUpload){
    deputesAppealService.add(deputesAppeal, fileUpload);
    return "mainPage";
}

@RequestMapping(value = "mainFrame/deleted", method =
RequestMethod.GET)
public String deleteAppeal(@RequestParam(value = "id", required =
true) Integer id, Model model){
    deputesAppealService.delete(id);
    model.addAttribute("id", id);
    return "deletedPage";
}

@RequestMapping(value = "mainFrame/editPage", method =
RequestMethod.GET)
public String GetEdit(@RequestParam(value = "id", required = true)
Integer id, Model model){
    model.addAttribute("editedAppeal",
deputesAppealService.getById(id));
    return "editPage";
}

@RequestMapping(value = "mainFrame/editPage", method =
RequestMethod.POST)
public String editCurrentAppeal(@ModelAttribute("userAttribute")
DeputesAppeal deputesAppeal,@RequestParam(value = "id", required =
true)Integer id, Model model) {
    deputesAppeal.setNumber(id);
    deputesAppealService.edit(deputesAppeal);
    model.addAttribute("id", id);
    return "editedPage";
}
}

当我在 JSP 页面上提交输入数据时,我会处理下一个错误

HTTP Status 500 - Request processing failed; nested exception is
org.springframework.dao.DataIntegrityViolationException: could not
execute statement; SQL [n/a]; nested exception is
org.hibernate.exception.DataException: could not execute statement

上传文件的域

@Entity
@Table(name = "UploadFiles")
public class UploadFiles implements Serializable {

@Id
@GeneratedValue
@Column(name = "FILE_ID")
private long id;

@Column(name = "FILE_NAME")
private String fileName;

@Column(name = "FILE_DATA")
private byte[] data;

@ManyToOne
@JoinColumn(name = "ID")
private DeputesAppeal deputesAppeal;

public UploadFiles(){}

public UploadFiles(long id, String fileName, byte[] data){
    this.id = id;
    this.fileName = fileName;
    this.data = data;
}

public long getId() {
    return id;
}

public String getFileName() {
    return fileName;
}

public void setFileName(String fileName) {
    this.fileName = fileName;
}

public byte[] getData() {
    return data;
}

public void setData(byte[] data) {
    this.data = data;
}

public DeputesAppeal getDeputesAppeal() {
    return deputesAppeal;
}

public void setDeputesAppeal(DeputesAppeal deputesAppeal) {
    this.deputesAppeal = deputesAppeal;
}

原文由 O.Kuz 发布,翻译遵循 CC BY-SA 4.0 许可协议

阅读 788
1 个回答

对于遇到此问题的任何其他人 - 它与您尝试插入的数据有关 - 对我来说,它试图插入一个比 Hibernate 注释中设置的大小长的字符串。在调试时,可以根据Exception的原因来查找根本原因。

原文由 Geoff Lentsch 发布,翻译遵循 CC BY-SA 3.0 许可协议

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题