When I use Hibernate write a Image into database(Oracle10g)
MY code like these,but when I run it ,it has ClassCastExcetiion
(Blob blog=(BLOB)tp.getTp())
the type of tp.getTp() is Blob


/**
*
* @param filename String
* @param tp TuPian
* @throws FileNotFoundException
* @throws IOException
*/
public void addTuPian(String filename, TuPian tp) throws
FileNotFoundException, IOException, SQLException, HibernateException {
byte[] buffer = new byte[1];
try {
session = sessionFactory.openSession();
transaction = session.beginTransaction();
tp.setTp(Hibernate.createBlob(buffer));
session.save(tp);
session.flush();
session.refresh(tp, LockMode.UPGRADE);
BLOB blob =(BLOB) tp.getTp();
// out =blob.getBinaryStream();
File file = new File(filename);
FileInputStream infile = new FileInputStream(file);
byte[] data = new byte[ (int) infile.available()];
infile.read(data);
infile.close();
session.flush();
transaction.commit();
}
catch (HibernateException e) {
if (null != transaction) {
transaction.rollback();
e.printStackTrace();
}
}
finally {
session.close();
}
}

Who can help me??
I am worry about it for four days!!

Hi,

note that there are two different types of Blobs:

java.sql.Blob: the Java standard Type
oracle.sql.BLOB: the oracle driver's type

It seems to me that you cast from one to the other
(In your code, you write sometimes BLOB, sometimes Blob)



Anyway, I have not yet managed to read a blob from an Oracle database using Oracle's DB driver - it is simply too buggy.
The only driver that worked so far was the Oracle driver by DataDirect
(http://www.datadirect.com)

However, this one is not really cheap...

regards,
Stefan

I advice you to read http://www.hibernate.org/56.html (Using Clobs/Blobs with Oracle and Hibernate)

Personnaly, I used the driver 10g with a Oracle 9.02 and I works good.