Hi there, does anyone know how to map an image to the database? I am using postgresql.


Cheers,
Brad

You may use a Byte[]; read property mapping

Yeah you'll want to use a Byte[] type on the object. For the hibernate mapping the Byte[] datatype works for small images but it will cut off large images and files. You'll need to use BinaryBlob from the Large Object Mapping Types to store larger files.

So you'll probably want to use the blob datatype for the postgresql column, Byte[] field on the object and set BinaryBlob on the NH property.

Ignoring the technical side of things I have always found it's better to store images and other files directly on the filesystem. It makes backup easier, it's faster, and the files are directly available to other systems.

Thanks very much for your replies, it is greatly appreciated.

You might want to check this out:

http://blog.calyptus.eu/seb/2009/03/lar ... and-xlobs/

Currently it's a work in progress but I'm actually working on an implementation of this for PostgreSQL Large Objects.