Hibernate 读写Blob和Clob的问题!
今天练习了一下读写Blob和Clob发现点问题~不知道如何解决了.
如果在Test中只调用reader() 那么一切正常,
但是如果现调用insert() 那在reader()读取到最后一条记录的时候就会出现异常
Exception in thread "main" java.lang.UnsupportedOperationException: Blob may not be manipulated from creating session
at org.hibernate.lob.ClobImpl.excep(ClobImpl.java:128)
at org.hibernate.lob.ClobImpl.getSubString(ClobImpl.java:94)
at org.hibernate.lob.SerializableClob.getSubString(SerializableClob.java:37)
at com.xl.test.Text.reader(Text.java:77)
at com.xl.test.Text.main(Text.java:34)
Text.java:77指向的却有是一条Clob语句!!苦闷啊~~下边是关键代码.
package com.xl.vo;import java.sql.Blob;import java.sql.Clob;/** * Userinfo entity. * * @author MyEclipse Persistence Tools */public class Userinfo implements java.io.Serializable { // Fields private Integer id; private Blob faceimag; private Clob remark; // Constructors /** default constructor */ public Userinfo() { } // Property accessors public Integer getId() { return this.id; } public void setId(Integer id) { this.id = id; } public Blob getFaceimag() { return this.faceimag; } public void setFaceimag(Blob faceimag) { this.faceimag = faceimag; } public Clob getRemark() { return this.remark; } public void setRemark(Clob remark) { this.remark = remark; }}package com.xl.test;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.sql.Blob;import java.sql.Clob;import java.sql.SQLException;import java.util.Iterator;import java.util.List;import org.hibernate.Hibernate;import org.hibernate.Session;import org.hibernate.Transaction;import com.xl.se.HibernateSessionFactory;import com.xl.vo.Userinfo;public class Text { /** * @param args */ private static Session session = HibernateSessionFactory.getSession(); public static void main(String[] args) { //如果不执行insert()那么就将一切正常~~~ String filePath = new File("bin").getAbsolutePath()+"\\image\\1.jpg"; insert(filePath); System.out.print("插入成功!"); reader(); } private static void insert(String filePath){ try { FileInputStream file = new FileInputStream(filePath); Blob blob = Hibernate.createBlob(file); Userinfo user = new Userinfo(); user.setFaceimag(blob); Clob clob = Hibernate.createClob("This is Clob DataType"); user.setRemark(clob); Transaction tra = session.beginTransaction(); session.save(user); tra.commit(); file.close(); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } private static void reader(){ try { InputStream is = null; FileOutputStream file = null; List list = session.createQuery("from Userinfo").list(); Iterator it = list.iterator(); int count = 0; while(it.hasNext()){ count++; System.out.println(count); Userinfo user = (Userinfo)it.next(); int id = user.getId(); Clob clob = user.getRemark(); String remark = clob.getSubString(1, (int)clob.length());//这句话报异常 System.out.println(remark); Blob blob = user.getFaceimag(); is = blob.getBinaryStream(); file = new FileOutputStream("d://"+count+".jpg"); byte [] bytes = new byte[1024]; int len; while((len = is.read(bytes)) != -1){ file.write(bytes); } } is.close(); file.flush(); file.close(); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } }}