Liquibase support for CLOB data

General Discussion
1

I have several relations that contain CLOB data.  I would like to insert data into these CLOB fields with INSERT and/or LOAD DATA.  I have noticed several postings that mention an attribute of COLUMN called “valueClob”.  However, when I use that attribute the parser complains:


Liquibase updateSql Failed: Error parsing line 25 column 71 of insertChangeSet.xml: cvc-complex-type.3.2.2: Attribute ‘valueClob’ is not allowed to appear in element ‘column’.


The line in question contains:


 



I am using Liquibase version 3.1.1 with reference to the XSD version 3.1.  Am I doing something wrong?


2

Nevermind.  I downloaded the XSD and saw many “refactorings” that aren’t in the documentation such as valueClobFile.  With a little more reengineering I found the correct syntax and action.

3

Thanks for pointing it out. I’m working on imporoving the docs.


Nathan