Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    7

    Unanswered: Persisting serialized object

    Hi Everyone.

    I have a situation where I need to persist an object that will serialized to binary.

    Is the best choice of data type a BLOB?

    Also, since I need to specify a length is it okay to use something like 1 GB since the field is variable length? I can assume the size of the object will never be over 1 GB.

    Are there any database settings taht would need checked or modified for using BLOB data? The table will be accessed via JDBC.

    I'm have DB2 v9.1 on Linux.

    Thanks.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    A BLOB is pretty much like any other data type. The only difference comes with logging in DB2 itself.

    Whether a BLOB is the best choice depends on your requirements.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •