I want store a list of values into a single column as serializable object.

Hibernate maps serializable to RAW in Oracle.

The problems are:
1. RAW has fixed size which may consume a lot of meory if objects are small
2. RAW can store upto 2000 bytes which can not host any reasonable list of objects.

If I could map serializable to BLOB or LONG column, these two problems would have been solved.

Any thought?

Thanks, Paul

Hi,

you can overide the sql type which maps to a specific Hibernate type.

Just look at this code snippet... If you don't know the exact spelling of the desired type just go to the Hibernate sources and have a look into the database dialect class you're using in your config eg. org.hibernate.dialect.Oracle9Dialect



Greetz
Benjamin