version control - Unable to tag the database using Liquibase for future rollback -


i trying tag database future rollback using getting below error:

applying updates database. may take few minutes ... unexpected error running liquibase: error parsing line 12 column 6 of ppsdb/ebidb_lb_upgrade_c43_sql_1.xml: cvc-complex-type.2.4.a: invalid content found starting element 'sql'. 1 of '{"http://www.liquibase.org/xml/ns/dbchangelog/1.9":modifysql}' expected.

here changeset file:

cat ebidb_lb_upgrade_c43_sql_1.xml

<?xml version="1.0" encoding="utf-8"?> <databasechangelog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd"> <changeset author="avnish_plsql_upgrade" id="1"> <tagdatabase tag="version_1.3"/> <sql         stripcomments="false" > create table test (id number); </sql> </changeset> </databasechangelog> 

when removing tagdatabase tag file, not getting error. when adding tag, getting above error. please let me know, if missing thing or making mistake here.

i think issue may using outdated xsd. in header of xml file, replace instances of 1.9 3.6

here example 1 of recent environments:

<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.6.xsd"> 

Comments

Popular posts from this blog

node.js - Node js - Trying to send POST request, but it is not loading javascript content -

javascript - Replicate keyboard event with html button -

javascript - Web audio api 5.1 surround example not working in firefox -