0 Replies Latest reply on Feb 13, 2005 2:03 PM by sailendra Nath

    Storing Object Messages in a CHAR field

    sailendra Nath Newbie

      Hi friends,

      My application uses Informix SE as database and the application deals with Object Messages. I want to use the Informix SE for message persistance.But I have a problem. Informix SE does not support BLOB datatype.So I have to store the Object messages in a CHAR field.
      When I give BINARYSTREAM_BLOB in informix-jdbc2-service.xml I am able to store messages in the CHAR (32000) field.But when Jboss tries to read the message from the database it gives error 'cant convert to Binary Stream'.I also tried different BLOB type option like OBJECT_BLOB,BYTES_BLOB with no success.

      Any suggestion is greatly appreciated.