怎么上传文本可以而图片不可以
数据库是SQL SERVER,字段是IMAGE类型.用STRUTS里面的组件.
FormFile file = theForm.getTheFile();
...
InputStream stream = file.getInputStream();
...
mSql = "insert into MyImage (id,body) values (?,?)";
prestmt = conn.prepareStatement(mSql);
prestmt.setString(1, "eee");//!!
prestmt.setBinaryStream(2, stream, file.getFileSize());
conn.setAutoCommit(true);
prestmt.executeUpdate();
conn.commit();
怎么上传文本可以而图片不可以?很奇怪.错误为:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated.
长度应该够了啊