Questions tagged [liquibase-sql]
113 questions
1
vote
1 answer
Liquibase How to escape Changelog Property Substitution
Is it possible to escape the Liquibase Changelog Property Substitution?
This is my Changeset:
INSERT INTO TABLE_NAME (VALUE, DESCRIPTION) VALUES (
…
Marvin
- 11
- 2
1
vote
3 answers
How to run the liquibase docker image in Jenkins containerized docker environment
I'm doing POC with liquibase docker image,
I would like to run the liquibase docker image in docker with Jenkins kubernetes POD template. unfortunately unable to make it.
And also I have attached the Jenkins file and my observation.
Jenkins File
def…
Ramakrishnan M
- 482
- 1
- 6
- 16
1
vote
0 answers
How to use sql procedure or while/for loop in liquibase 4.0.0?
I want to use for/while loop in sql file.
So defined the proc sql. btw there is an error.
guofu
- 11
- 3
1
vote
2 answers
Liquibase generated change log throws SQL Syntax Exception
I've generated a change log for an existing database using Liquibase's generateChangeLog command. However when I try to run this an SQLSyntaxErrorException is thrown.
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax;…
Andrew Myers
- 23
- 1
- 1
- 6
1
vote
0 answers
Liquibase diffChangelog does not generate rollback
If I haven't misunderstood anything, the liquibase command diffChangelog should be able to generate rollback change sets for some types of change sets like create table, rename column or add column but it is not working for me using the liquibase…
Fran García
- 2,011
- 16
- 24
1
vote
3 answers
Failed to read schema document 'http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.8.xsd'
I have installed Liquibase runner 1.3.0 plugins in Jenkins and trying to execute liquibase changelog script file which I got after executing 'diffChangeLog' command. While executing script file, I am getting Failed to read schema document…
Rohan
- 29
- 1
- 3
1
vote
2 answers
Can I suppress DatabaseChangeLogLock table creation?
I have a schema (for application users) where only one script (creating synonyms) runs. I don't have INSERT/UPDATE/CREATE privileges on that schema. Can I suppress the creation of audit tables (i.e. DATABASECHANGELOGLOCK & DATABASECHANGELOG tables)…
Vaibhav Gupta
- 353
- 1
- 2
- 17
1
vote
1 answer
liquibase sqlFile complains that "File does not exist"
So, a while back I moved all of our database functions and view to individual files for better change control. Today, I deleted a function and therefore I deleted the file for that function. However, the original changeLog from 2019.Q2.R1 still…
Victor Rodriguez
- 75
- 2
- 8
1
vote
1 answer
Can we monitor newly added data inside database table using Liquibase?
I want to monitor newly added data inside database table using Liquibase.
I have found out that we can do Create, Insert, update, delete, rollback types of operations on table but I not sure whether we can perform read operation to see actual data.
Harsh
- 47
- 2
- 9
1
vote
2 answers
Liquibase preconditions to all changelog file in sql
I would like to run a SQL precondition checking for each changeSet in my SQL changeLogFile. It is actually a precondition on the changeLog itself
Here is an extract of it :
--liquibase formatted sql
--preconditions onFail:HALT…
Cedric C
- 11
- 2
1
vote
1 answer
Liquibase rollback not working in Sprintboot 2.0
How does liquibase rollback works with springboot application? Would appreciate your inputs.
Here is what i tried - I am creating TableA and TableB in Oracle within a changeset.
TableB already exists in the database, I expect liquibase to rollback…
bigskull
- 739
- 2
- 13
- 23
1
vote
0 answers
Liquibase update very slow when migrate from 3.5.5 to 3.6.0 or superior
I m using liquibase in version 3.5.5 and my script ran fast, about 20 secondes to execute all of my script from scratch.
Recently i have update my version to 3.6.3 and now, global time of execution is pass to 20minutes!! I have change nothing in my…
Mançaux Pierre-Alexandre
- 858
- 1
- 11
- 42
1
vote
1 answer
No Enum constant Exectype E
I am trying to execute a change in colum length for a table usuing liquibase with the below code:
user1318369
- 715
- 5
- 15
- 34
0
votes
0 answers
Liquibase error IDENTITY_INSERT is set to OFF
I am using Liquibase tool for database migration from one database(MSSQL) to other database(MSSQL). I am able to generate change xml file using generateChangeLog command which has create and insert queries. so far its good.
Now when I try to execute…
Sohan Badaya
- 365
- 4
- 15
0
votes
0 answers
Liquibase Upgrade Causes Certain Changesets to Rerun
Upgrading from Liquibase 4.4.2 to 4.23.0 (I know, shame on us for the lag) causes certain changesets to rerun in our existing databases. We then tried all of the versions from 4.23.0 down to 4.19.1 with the same result. Seemingly only changesets…
DDirkson
- 1
- 1