With Hibernate 2.1-* you can use the following mapping strategy:

   <property name="name" type="text" />

It will map your string to a TEXT column if supported (it is for 
MySQL) or CLOB... (cfr. Reference doc, 4.2.2. Basic value types)