Observation schemaVersion in XML DB scripts must match jOOQ liquibase version

[Rob Walker]

This may have been found / reported / widely known, but thought I would pass on anyway.

We hit an odd issue doing clean builds when offline (no internet connection)

Turns out the XSD reference in our DB XML files was different to the liquibase version specified in the jOOQ dependencies (ours was 4.1 and jOOQ is 3.8).

This cause no issues normally, but a clean build offline fails because it can't find the XSD. Correcting the last attribute of our top level databaseChangeLog XML element cured this.

<databaseChangeLog  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
                    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
                    xmlns:pro="http://www.liquibase.org/xml/ns/pro"
                    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-3.8.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.8.xsd">

Just passing on as a tip for others!