Liquibase unable to connect with DB2

General Discussion
1

Using JDBC Layer, we are trying to connect with db2 to create snapshots and to perform diff operations. We are getting the following error for all liquibase calls with db2.
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][XXX.XXX.XXX] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
Please help me out as this

2

Hi @jayanthit ,

Sorry you are having issues using liquibase with your DB2 target. To better diagnose we will need more info:

  • What version of liquibase are you using?
  • What is the exact command you are running (ex. liquibase update)
  • Send back complete error log (not just snippet, please set logLevel=DEBUG in your liquibase.properties file or at the commandline)

Quick google search on error code 4220 for DB2 turned up this, which indicates that you may have incompatible fields types with unicode. Note I believe that db2 should be setup up as UTF-8 to work with liquibase.

Thanks,

Ronak