I solved my problem.
I am using XDoclet to generate my bean interfaces and xml files etc.
I forgot to add @jboss tags to my beans so that the jbosscmp-jdbc.xml file includes tags to overwrite the default cmp mapping (string to varchar) to be from string to clob for those specific long string fields that i want.
Can you please post extracts of your descriptors/code.
I cannot get CMP Entity Bean store of a Clob field > 4000 characters to work. Less than is fine and reading is OK, but storing > 4000 results in the column being set to null.
Many thanks in advance
What exactly did you use for the mappings of jdbc-type and sql-type in xdoclet tags ?