java preparedstatement null_java – 使用PreparedStatement将blob设置为null

我正在使用JSF2.0创建webapplication,在

mysql中,我使用数据类型作为MEDIUMBLOB存储图像.

要插入值,我使用PreparedStatement,如下所示.

PreparedStatement psmnt = con.prepareStatement("INSERT INTO sketchesSG002003 (userid, imageTitle, imageData, drawingComments) VALUES (?,?,?,?)");

psmnt.setLong(1, personalInfoId);

psmnt.setString(2, sketchesSG002003Title);

try {

String fileName = FilenameUtils.getName(sketchesSG002003ImageUpload.getName());

File image = new File(fileName);

InputStream fis = sketchesSG002003ImageUpload.getInputStream();

psmnt.setBinaryStream(3, fis, (int) sketchesSG002003ImageUpload.getSize());

} catch (Exception e) {

psmnt.setBinaryStream(3, null);

}

psmnt.setString(4, sketchesSG002003Comments);

i = psmnt.executeUpdate();

但是我收到了错误

java.lang.AbstractMethodError: com.mysql.jdbc.PreparedStatement.setBinaryStream(ILjava/io/InputStream;)V

Stacktrace的某些部分是

javax.faces.el.EvaluationException: java.lang.AbstractMethodError: com.mysql.jdbc.PreparedStatement.setBinaryStream(ILjava/io/InputStream;)V

at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

at javax.faces.component.UICommand.broadcast(UICommand.java:315)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)

我相信上面的错误是对于语句psmnt.setBinaryStream(3,null);

我的问题是如何将二进制数据设置为Null或Nothing？