Hello,

I am working with an hibernate application but trying to use an informix database instead of the mySQL one.

The application uses a CLOB java.sql.type but the informix dialect in hibernate does not recognise this type.

I downloaded the latest hibernate source 3.2ga and added the extra registration to the InformixDialect.java file and rebuilt hibernate.

registerColumnType(Types.CLOB, "text");

This corrected the issue I was having.

Perhaps someone who maintains the informix part of hibernate can check if this is correct in general?

Perhaps Types.BLOB is also needed?