1. Bolb类型字段说明:
这需要你先插入一个empty的blob,这将创建一个blob的cursor,然后你再把这个empty的blob的cursor用select查询出来,这样通过两步操作,你就获得了blob的cursor,可以真正的写入blob数据了。
2. 获取游标存在的问题:
代码示例:
//PO:CardSuitInfo
public class CardSuitInfo implements Serializable ...{
private java.sql.Blob cardFacePicFile;
public void setCardFacePicFile(Blob cardFacePicFile) ...{
this.cardFacePicFile = cardFacePicFile;
}
public java.sql.Blob getCardFacePicFile() ...{
return this.cardFacePicFile;
}
}
//1.首先插入空的blob
cardSuitInfo.setCardFacePicFile(net.sf.hibernate.Hibernate.createBlob(new byte[1]));
session.save(cardSuitInfo);
session.flush();
//2.写入blob
session.refresh(cardSuitInfo, LockMode.UPGRADE);// 设置锁定级别
weblogic.jdbc.wrapper.Blob weblogicBlob = (weblogic.jdbc.wrapper.Blob) cardSuitInfo.getCardFacePicFile();
oracle.sql.BLOB oracleBlob = (oracle.sql.BLOB) weblogicBlob.getVendorObj();
OutputStream out = oracleBlob.getBinaryOutputStream();
byte[] buffer = cardSuitInfoView.getCardFacePicFileBody();
out.write(buffer, 0, buffer.length);
out.close();
session.save(cardSuitInfo);
//PO:CardSuitInfo
public class CardSuitInfo implements Serializable ...{
private java.sql.Blob cardFacePicFile;
public void setCardFacePicFile(Blob cardFacePicFile) ...{
this.cardFacePicFile = cardFacePicFile;
}
public java.sql.Blob getCardFacePicFile() ...{
return this.cardFacePicFile;
}
}
//1.首先插入空的blob
cardSuitInfo.setCardFacePicFile(net.sf.hibernate.Hibernate.createBlob(new byte[1]));
session.save(cardSuitInfo);
session.flush();
//2.写入blob
session.refresh(cardSuitInfo, LockMode.UPGRADE);// 设置锁定级别
weblogic.jdbc.wrapper.Blob weblogicBlob = (weblogic.jdbc.wrapper.Blob) cardSuitInfo.getCardFacePicFile();
oracle.sql.BLOB oracleBlob = (oracle.sql.BLOB) weblogicBlob.getVendorObj();
OutputStream out = oracleBlob.getBinaryOutputStream();
byte[] buffer = cardSuitInfoView.getCardFacePicFileBody();
out.write(buffer, 0, buffer.length);
out.close();
session.save(cardSuitInfo);
读取blob字段:
......
weblogic.jdbc.wrapper.Blob weblogicBlob = (weblogic.jdbc.wrapper.Blob) cardSuitInfo.getCardBackPicFile();
oracle.sql.BLOB oracleBlob = (oracle.sql.BLOB) weblogicBlob.getVendorObj();
BufferedInputStream in = new BufferedInputStream(oracleBlob.getBinaryStream());
long picLong = cardSuitInfo.getCardBackPicFile().length();
byte [] bytes = new byte [Integer.parseInt(picLong + "" )]; //
int result = in.read(bytes);
if (result > 0 ) ... {
downloadFileView.setFileByteArray(bytes);
}
in.close();
......
......
3.总结:
weblogic进行的封装,使我们必须加这步转换,如果用jdbc操作就不会出现此问题,而直接可以转化为oracle.sql.BLOB的对象。
重点步骤:
weblogic.jdbc.wrapper.Blob weblogicBlob = (weblogic.jdbc.wrapper.Blob) cardSuitInfo.getCardBackPicFile();
oracle.sql.BLOB oracleBlob = (oracle.sql.BLOB) weblogicBlob.getVendorObj();