grails - [B不能强制转换为java.sql.Blob

这是我的 Realm 类(class)

class TimesheetSubmission {

    Date submissionDate=new Date()
    String foreman
    String shift
    String jobId
    Date date
    byte[] xmlSubmission
    String xmlResponse

    static constraints = {
         submissionDate nullable: false
         foreman nullable: false
         shift nullable: false
         jobId nullable: false
         date nullable: false
         xmlSubmission nullable: true
         xmlResponse nullable: false
    }
    static mapping = {
        xmlSubmission (type: "blob")
    }
}

以下是我的代码将数据持久存储在数据库中。

TimesheetSubmission timesheetSubmission=new TimesheetSubmission()
timesheetSubmission.foreman=Party.findById(foremanId)
timesheetSubmission.shift=shift
timesheetSubmission.jobId=jobId
timesheetSubmission.date=Date.parse("yyyy-MM-dd", date)
timesheetSubmission.xmlSubmission=sTimesheet.getBytes();
timesheetSubmission.xmlResponse="response"
timesheetSubmission.save(flush: true,failOnError: true)

在domain上应用保存时出现以下错误。

[B cannot be cast to java.sql.Blob

最佳答案

static mapping = {
    xmlSubmission sqlType: 'blob'
}