Iam trying to map String array to table of column type Clob. Iam using following XDoclet.
* @hibernate.array table="ITEM_DATA" cascade="all"
* @hibernate.collection-index column="DATA_IDX"
* @hibernate.collection-key column="DATA_ID"
* @hibernate.collection-element column="DATA" type="java.sql.Clob"

is there anything wrong with this mapping. Iam getting following exception.
java.lang.ClassCastException
at net.sf.hibernate.type.ClobType.set(ClobType.java:27)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48)
at net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:35)
at net.sf.hibernate.collection.AbstractCollectionPersister.writeElement(
AbstractCollectionPersister.java:384)
at net.sf.hibernate.collection.ArrayHolder.writeTo(ArrayHolder.java:112)

at net.sf.hibernate.collection.AbstractCollectionPersister.recreate(Abst
ractCollectionPersister.java:523)
at net.sf.hibernate.impl.ScheduledCollectionRecreate.execute(ScheduledCo
llectionRecreate.java:23)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2375)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.jav
a:52)

[b]Hibernate version:[/b]

[b]Mapping documents:[/b]
* @hibernate.array table="ITEM_DATA" cascade="all"
* @hibernate.collection-index column="DATA_IDX"
* @hibernate.collection-key column="DATA_ID"
* @hibernate.collection-element column="DATA" type="java.sql.Clob"
[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:[/b]

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]

Did you find a solution to this problem? I might want to use something similar. If not I could always turn the String Array into a collection of simple POJO's.