Hibernate 读写Blob和Clob的问题!

radium0028 2008-01-02 11:52:44

今天练习了一下读写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();

		}

	}

}

...全文

1586 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

marlonjlz 2011-08-03

打赏
举报

一个Session中只能存在一个Hibernate.createClob（），你的某些转化工作与其冲突了

响耳 2008-05-21

打赏
举报

关注中。我所遇到的现象是，单独调用Hibernate.createClob("test");方法，就有可能出现异常。而且异常信息较怪：Caused by: java.lang.UnsupportedOperationException: Blob may not be manipulated from creating session，希望能得到解决办法。

umbrella_yxs 2008-01-04