title: How do I get Grails to map my String field to a Clob?
body: <p>My domain class looks like this:</p>
  
  <pre><code>package com.initech.tps
  
  class Foo
  {
      String stuff
  
      static mapping = {
          // mapping to a legacy table as opposed to letting Grails create it
          table name: 'FOO', schema: 'TPS'
          id generator: 'sequence', params: [sequence: 'MY_SEQ'], 
              column: 'FOO_ID', sqlType: 'integer' 
          foo column: 'STUFF'
      }
  
      static constraints = {
          stuff(nullable: true, maxSize: 40000)
      }
  } 
  </code></pre>
  
  <p>I was under the impression Grails would figure out to use a CLOB instead of a VARCHAR based on my passing in a big enough value for the maxSize constraint, instead I get this error message in the console:</p>
  
  <pre><code>org.hibernate.HibernateException: Wrong column type in FOO for column STUFF. 
  Found: clob, expected: varchar(40000)
  </code></pre>
  
  <p>Do I need an explicit sqlType on the mapping? I tried using different values of maxSize, and leaving it out altogether, with no difference. Also adding <code>sqlType: clob</code> or <code>sqlType: text</code> doesn't work.</p>
  
  <p>I'm on Grails 1.3.7, using IBM DB2-Express.</p>