Hello.

I'm a begginer with Java and Hibernate. Have an important project for college. I hope somebody can help me. Thank you.
Hibernate version:3.2
Mapping document:
<property name="Image" column="IMAGE" type="binary" not-null="false" /> </property>
Code between sessionFactory.openSession() and session.close():

Session session = sessionFactory.getCurrentSession();
Blob result = null;
try {
session.beginTransaction();
Blob blob = (Blob) session.createSQLQuery("SELECT image as image FROM Imgsartic").addScalar("image").uniqueResult();
result = blob;
session.getTransaction().commit();
}
catch (Exception e) {
e.printStackTrace();
} return result;
Name and version of the database you are using:
Oracle Express 10g
JSP CODE:
<%
session.setAttribute( "ImgsArtic", revista.DAO.getImagen());
%>
<c:out value="${ImgsArtic}" />


Running the app shows next text:
org.hibernate.lob.SerializableBlob@135f92f

It seems corresponds to the "serial blob locator" I have reading these days from some people on forum.

I'm success working with clobs, but now with images and blobs I'm broken. The table has only 1 record. I don't know how to get and show the image on my jsp page.

Thank you very much for your time.
BM

use same name for your "propery" and "column" like image for both and
use "binary" for result variable like binary result.If you having blob data type in your Database then user mediumblob instead of blob because blob can store 64kb while mediumblob can store 16mb.

Thanks for the answer.

I used byte[] and doesn't work. Can't find nothing for "binary".