MyException - 我的异常网
当前位置:我的异常网» J2EE » in thread "main" java.lang.Unsupported

in thread "main" java.lang.UnsupportedOperationException:

www.MyException.Cn  网友分享于:2013-11-11  浏览:3088次
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语句!!苦闷啊~~下边是关键代码.

Java code

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;
    }

}



Java code

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();
        }
    }
}


文章评论

软件开发程序错误异常ExceptionCopyright © 2009-2015 MyException 版权所有