![]() INSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0) If I run liquibase updatesql i see the correct sql statements: - Create Database Lock TableĬREATE TABLE DATABASECHANGELOGLOCK (ID INTEGER NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TEXT, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)) If I put more sql statements in a file only the first one gets executed. sql files are the consecutive changelogs that must be run to update the DBīut now I have another issue. Testdb is the sqlite database I’m using to test liquibase. rw-r-r- 1 root root 2637 Sep 4 16:36 liquibase.properties rw-r-r- 1 root root 456 Sep 4 14:22 changelog-master.xml ĭrwxr-xr-x 5 username username 4096 Sep 4 17:02. This is the project’s structure, if you need it ls -laĭrwxr-xr-x 2 root root 4096 Sep 4 17:28. Unexpected error running Liquibase: cvc-elt.1.a: Cannot find the declaration of element ‘databaseChangeLog’.Īnd here is my problem, I’ve checked multiple times if I had some errors in the changelog-master.xml but it looks fine. ![]() The file is 000020-changelog.sql and contains -liquibase formatted sqlĬreate table phonebook(name TEXT, surname TEXT, type TEXT, phone_number TEXT) īut now when I launch liquibase update I get an XML Parsing error: sql changelog file (still in the same directory), which by documentation should be ran automatically after launching liquibase update. (the file is correct, because if i run a normal. Url=jdbc:sqlite://home/username/liquibase/examples/sqlite-test/testdb # Enter the Target database 'url' information # I’ve then created the liquibase.properties file in the same directory: # Enter the path for your changelog file.
0 Comments
Leave a Reply. |