we are using SQLServer2000 and we need to store a very large character stream(probably more than 10000 characters) in the db. I think we can use clob to represnt this. But looks like SQLServer doesn't support CLOB. Any suggestions??? I appreciate ur help.

I think text datatype can store upto 2GB information. But how to configure it in hibernate. I mean how to insert/update/retrieve/delete.

I appreciate your help.

You could read the documentation, "Basic Value Types".

Per documentation for long java strings we can use hibernate datatype "text", which internally maps to CLOB/TEXT. But my quetsion is in java Bean which data type I have to use? is it java.lang.String? I read some where that java string has maximum limit? I am not sure whether it's true or not.

I appreciate your help.

You can use a String mapped as a text type, if it is okay for you to read the whole text field into memory uppon loading. Otherwise use a java.sql.Clob mapped with it as type.