DB2 Usage Notes

LONG VARCHAR Fields

By default MyBatis Generator will map LONG VARCHAR fields to the java.lang.String data type, and will mark these fields as jdbcType="LONGVARCHAR". This mapping will cause errors when retrieving data from DB2. DB2 LONG VARCHAR fields should be mapped to the java.lang.String data type with jdbcType="VARCHAR". To overcome this problem, use a <columnOverride> as follows:

  <table schema="DB2ADMIN" tableName="ALLTYPES" >
    <columnOverride column="LONG_VARCHAR_FIELD" javaType="java.lang.String" jdbcType="VARCHAR" />
  </table>