Have an interesting problem. I am setting up an app against a DB2 v7 database (antiquated). The app has hibernate persisted objects with property specifications of the type:

<property name="blah" type="text".../>

Where the schema associated with the property in the database has the definition of:

clob(255)

Now... Currently when I go to retrieve objects having these I am getting a SQL Error: -351 back from the DB2 driver which is an error indicating an "unsupported type". I have isolated the problem strictly to this property def on the objects in question.

I have also tried hibernate type= of text, java.sql.Clob, clob... And none of these work.

Some questions:

1. Why use clob(255) versus vchar(255)?
2. Has anyone else seen this issue? Is there another type= specification I can use in the property?
3. Any suggestions.