We are planning to start supporting our application in DB2 8.1 FP2
Right now our application supports DB2 7.2
Any select or insert table with a CLOB columns throws the following exception,
java.lang.IllegalArgumentException: field type mismatch
My quesions are,
1. Application and CLOB data type worked fine with DB2 7.2 FP8. Any reason why DB2 8.1 FP2 JDBC driver (Type 4) does not support CLOB object?
2. our CLOB field length is 2GB, application runs when we replace CLOB with LONG VARCHAR, but maximum field length for LONG VARCHAR is only 32567 bytes.
What other SQL data types are available similar to LONG VARCHAR and that allows custom field length?