Hi Team,

I have a requirement to store an "java Object" or "XML" file to a table in DB2 v 8.1. The XML file can be of max size 100kb

Can you please suggest a db2 column type I should use?

You should use CLOB for that. Be aware that LOB columns don't perform as well as other column types because they do not make use of the Bufferpool memory caching.

If you can limit it to about 32000, you could use VARCHAR, but your tablespace and bufferpool pagesize would need to be 32K.

Do not use LONG VARCHAR, which is being depricated in future releases, and functions like a LOB but is limited ot 32K.

You may want to see the features of XML Extender as well ...

XML Extender has been deprecated, meaning that support for it will stop in some future release (the exact release this will happen has not been specified yet by IBM).

Thank you very much. I will then try the CLOB option as the file can be up to 1MB.

By any chance do you know the type we must use when saving the data to table using hibernate for CLOB.

Below what do we specify at ???.. should we just specify String and convert XML file to String and save it?
<property column="MyXML" name="myXML" type="????"/>

Hibernate Data Type-Java Data Type - SQL Data Type mapping

That is a excellent link.. Thank you. I will set the value to text and see what happens.. will try it today for sure.

power of google.