Hello everybody,
in my actual project we have the need to run the updateSQL from an Intellij (via plugin) and from a Jenkins process (of course using the same target Oracle DB)
Unfortunately I got “Validation Failed” … I have already set up the logicalpath to be the same …
Here what I did
In the table.xml file
> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd"
> logicalFilePath="src/main/resources/db/scripts/tables/attribute_value.xml">
I run the updateSQL from Intellij and I got this
INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE)
VALUES ('1439890345106-1', 'xxxxx', 'src/main/resources/db/scripts/tables/attribute_value.xml', SYSTIMESTAMP, 92,
'7:1af9602de533591c505295bb7acf4820', 'createTable', '', 'EXECUTED', NULL, NULL, '3.4.1');
Then I run insert statement into the DB (Oracle) … till here all is ok
Now I ran the Jenkins build process and I got the
Validation Failed:
1 change sets check sum
src/main/resources/db/scripts/tables/attribute_value.xml::1439890345106-1::xxxxx was: 7:1af9602de533591c505295bb7acf4820 but is now: 8:64800df46380c744bd812f9c7261406c
REading on internet I erase the checksum in the db to “recalculate” it … and the build was ok … but then I ran again Intellj and I got the same error …
Any suggestion?