Hello, I'm trying to map a java String field to an Oracle LONG type, in order to get around the 4,000 character limit on VARCHAR2s and to avoid the headaches of dealing with CLOBs.

My problem is that in my mapping, the various net.sf.hibernate.type.* classes I've tried haven't worked. net.sf.hibernate.type.StringType and CharacterType both said that my data size was bigger than the max size of 7306. I tried BinaryType and LongType; both, predictably, threw ClassCast exceptions.

Is there an appropriate type for this, or am I way off base? mapping snippet:

<property name="content" column="content" type="net.sf.hibernate.type.LongType">
<column name="content" sql-type="LONG" />
</property>

best,
John