generateChangeLog with --diffTypes=data throws error on LOB-Fields

Description

When trying to run liquibase --diffTypes=data generateChangeLog on a Apache Derby (via org.apache.derby.jdbc.ClientDriver) i get the following error:

This is caused by JdbcUtils.getResultSetValue(...) due to this change in derby: https://db.apache.org/derby/releases/release-10.6.1.0.html#Note+for+DERBY-3844

I did a short test; When Checking for MetaData-Types CLOB/BLOB and retrieve the CLOB/BLOB value only once as expected no error was thrown.

Reproducing the error:

  • create an empty Derby Database; e.g. with jdbcUrl: jdbc:derby://localhost:1527/emptyDBtest;create=true

  • run the following script for generating blob and clob data:

  • run liquibase from commandline: liquibase --diffTypes=data generateChangeLog

Environment

Derby 10.13.1.1

Activity

Show:

Details

Reporter

Components

Affects versions

Priority

Created May 22, 2018 at 1:34 PM
Updated May 22, 2018 at 1:34 PM