Questions tagged [liquibase-sql]
113 questions
0
votes
0 answers
Using Liquibase, script ran before previous change commited
Im using liquibase to run multiple scripts.
SQL Scrpt 1 : alter table script for Customers
SQL script 2: insert into customers.
Script 1 fails bc script 2 is trying to run while the table is being altered.
( ORA-00054: resource busy and acquire with…
GoHamz
- 1
0
votes
2 answers
Liquibase: Keep changes from script but remove the changelog in changelog table
I am using liquibase for applying database changes. I have below changeset and below are the entries in changelog:
Changeset:
…
ging
- 219
- 7
- 20
0
votes
1 answer
while creating a table using changlog file in liquibase it shows error
While creating a table in snowflake using the sql queries with changelog file in liquibase.In the schema DATABASECHANGELOGLOCK has created. But its shows the following error:
Unexpected error running Liquibase: SQL compilation error:
Object…
0
votes
1 answer
Liquibase - validation failed checksum changed
This is the first version of my changelog.sql:
-- liquibase formatted sql
-- changeset kh:1
CREATE TABLE test_table (test_id INT, test_column VARCHAR(256), PRIMARY KEY (test_id))
--changeset kh:2
INSERT INTO test_table (test_id, test_column)…
user1911
- 680
- 1
- 14
- 36
0
votes
0 answers
Vendor-independent SQL syntax for dropping unique and primary key constraints
Precondition:
I am using Liquibase with SQL scripts in my app. I started testing with Oracle DB, but now I need to switch to PostgreSQL DB.
Problem:
When I added constraints, I didn't add the names of the constraints.
Liquibase changelog contains a…
Yakov Stoykov
- 65
- 1
- 1
- 6
0
votes
1 answer
Move rows from one table to another liquibase
I need to drop one table, but before I need to move all the data that is in that table to another table with xml liquibase. I tried with update but it is giving ORA-00936: missing expression. Can someone help please ? What is the syntax / correct…
sticky_elbows
- 1,344
- 1
- 16
- 30
0
votes
0 answers
Liquibase sql execution using changelog.xml file included with main.sql
I am executing a main.sql file having 2 sub sql files inside main.sql file as createtable1.sql and createtable2.sql. when i am executing using liquibase getting error as invalid format
--liquibase formatted SQL
--changeset dev:1 runOnChange:true…
0
votes
1 answer
NodeJS - Liquibase - Postgres is not working
It would be very helpful if anyone provide some insight on the below issue,
I'm trying to build a NodeJS sample to update the PG DB using Liquibase changesets.
I've created a a postgres db successfully in my local using below commands,
CREATE…
0
votes
1 answer
How to write Liquibase script to hash the data of a column using update command
While I was trying to hash the owner_name column with this set of Liquibase Script as suggested by the Corda here:
I have used the PostgreSQL DB
0
votes
2 answers
Liquibase create schema for MySQL
Is there any way to create schema through liquibase script ?
After some research I've found out that we need to include a create schema in change log file.
I'm thinking on similar terms for question asked previously for postgres
Any pointers or…
Aԃιƚყα Gυɾαʋ
- 107
- 1
- 15
0
votes
1 answer
Liquibase incorrectly reads "--" symbols inside SQL script
I have next Liquibase formatted SQL script with PL/SQL block.
--changeset TASK-NNN-create_new_tasks endDelimiter:\\
DECLARE
email VARCHAR2(60) := 'some_person@example.com';
BEGIN
CREATE_TASK(
'new_task_1',
'python…
Alexander Khristosenko
- 61
- 1
- 10
0
votes
0 answers
Liquibase rollback in mysql is not working
I am trying to rollback the stored procedure which is created in mysql,
tables as employee, dept as usual.
the rollback is not working correctly.
not sure how to make it work.
--liquibase formatted sql
--changeset tester_1:test_id_4 endDelimiter:$$…
Juliana Ashok
- 3
- 5
0
votes
1 answer
How can I link to a liquibase changelog file inside a jar?
Currently, I have a multi-module maven spring project. I'm planning to separate one module and use it as a jar dependency. This module has all the liquibase change-log files that other modules in my project refer (through their own change-log…
0
votes
1 answer
How does Liquibase cross instance command
I want to ask whether liquibase supports cross instances, between instances can be connected if possible, is the command correct like this
.....\liquibase --changeLogFile=filename.sql update liquibase.command.url…
0
votes
1 answer
Liquibase context in changeset
The text below is from liquibase's contexts page https://docs.liquibase.com/concepts/changelogs/attributes/contexts.html
By default, a database update runs all changesets in the changelog,
regardless of what you specify in the CLI.
If you add a…
murohima_1
- 67
- 1
- 7