Stack Overflow
Stack Overflow

Questions tagged [liquibase]

Liquibase is an open source, database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes are stored in a human readable yet trackable form and checked into source control.

Liquibase Supports:

  • Extensibility
  • Merging changes from multiple developers
  • Code branches
  • Multiple Databases
  • Managing production data as well as various test datasets
  • Cluster-safe database upgrades
  • Automated updates or generation of SQL scripts that can be approved and applied by a DBA
  • Update rollbacks
  • Database ”diff“s
  • Generating starting change logs from existing databases
  • Generating database change documentation

Resources

3764 questions
1
vote
1 answer

Liquibase lock error AFTER database creation

I'm currently running a DDL Script using the Liquibase Java API. The whole script and the corresponding changeSet is exceuted successfully. However, after this execution Liquibase throws a LockException. The ERROR LOG is as follows, 21713 [main]…
Srinivas Kini
  • 11
  • 1
  • 2
1
vote
0 answers

How to create schemas dynamically using a single changeset liquibase

We are new to liquibase and gradle plugin we would like to create multiple schema's Was able to create this script but it only creates only the last schema 'temp5' and not the other schema's in the list, may be we are missing the knowledge of how…
user2359997
  • 561
  • 1
  • 16
  • 40
1
vote
2 answers

Liquibase maven plugin with JDK11 failing with ClassNotFoundException: XmlElement

I'm using Apache Maven 3.3.9 Java version: 11.0.5 And the latest version of liquibase-maven-plugin as follows: org.liquibase liquibase-maven-plugin …
Elena
  • 501
  • 1
  • 6
  • 15
1
vote
1 answer

Liquibase with Postgres, changelog parameters are not replaced

I'm using liquibase with oracle and postgres and I would like to use the changeLog properties to customize the elements of the changeSets that are different in the two databases. I'm using the example from…
Maura
  • 15
  • 4
1
vote
1 answer

Jhipster jdl adding fake data LocalDate field is null in the database, Date format issue

I generate an entity with jhipster import-jdl hello.jdl entity Hello { title String, myDate LocalDate } Default fake data is generated hello.csv id;title;myDate 1;mobile Fish;2019-11-17 2;Savings Account Dam;2019-11-18 Problem However…
The Manthis
  • 87
  • 5
1
vote
1 answer

liquibase diff hibernate and jpa models vs an empty database throws could not build classFile

i have a multi microservices project, one microservice is named Foo, under the Foo service pom i added a plugin for liquibase with hibernate like so: org.liquibase liquibase-maven-plugin …
Omar Ajmi
  • 180
  • 1
  • 13
1
vote
1 answer

How do I add a constraint to this table using sql?

I have a table called Student and this table has 2 columns Student_Id and Is_Honor_Student (this is a flag column either 0 or 1 to represent true/false) I have another table called Honor_Student which has 2 columns Student_Id and Class_Id, along…
ronapple14
  • 93
  • 2
  • 10
1
vote
1 answer

Liquibase & MySQL 5.7 timestamp column modification problem

I have a column called updated_time it has a timestamp data type assigned: `updated_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP The problem is that currently, this column supports a second precision. I need it to be able to store a…
Ihor M.
  • 2,728
  • 3
  • 44
  • 70
1
vote
1 answer

Migrate auto generated IDs from Oracle to SQL Server

I am currently developing a java application to migrate data of an Oracle database to an equivalent structured SQL Server database which I have migrated using liquibase. Now I could not figure out how to migrate the auto generated IDs as well since…
Mad Scientist
  • 857
  • 4
  • 16
  • 43
1
vote
2 answers

How to flatten liquibase migrations into a schema init file?

In our current project we are using liquibase to manage DB migrations. Our migrations are *.sql files. We have currently 156 such migrations in master. Our project is a spring boot application, and the DB used is PostgreSQL 9.6. To make DB init…
le-doude
  • 3,345
  • 2
  • 25
  • 55
1
vote
1 answer

Use Liquibase autogenerated xml for Corda Enterprise DB migration

I switched to Corda Enterprise mainly to try how it handles automated database migration. In the documentation here it says tools-database-manager generates only SQL version of Liquibase script for initial DB and SQL version is Database specific so…
Andranik
  • 2,729
  • 1
  • 29
  • 45
1
vote
0 answers

Liquibase 3.7.0 on Azure - Unexpected Liquibase Exception: Cannot find LockService

I am currently working on a Java8 WebApp with Hibernate and Vaadin and Liquibase as a dependency which I tried to run on Azure for testing.I didn't write this app myself and the version that was given to me was originally using Liquibase 3.0.7 and…
Chaz
  • 672
  • 1
  • 5
  • 19
1
vote
0 answers

Error while executing oracle procedure using liquibase

I am trying to run the following using liquibase --liquibase formatted sql --changeset id:1 DECLARE str varchar(30); BEGIN str := 'something'; update table_name set comment = str where id=1; END; But I am getting the following error. How…
harv3
  • 263
  • 1
  • 6
  • 19
1
vote
2 answers

redefine local liquibase properies that are still visible in included files

Some of my tables implement concepts that need certain columns. I want to avoid having to copy the changesets for those columns to all relevant tables and would instead rather reuse a template to create the actual changesets. Based on different…
Holly
  • 1,305
  • 2
  • 15
  • 30
1
vote
1 answer

Why is liquibase trying to recreate the table DATABASECHANGELOG

I created a liquibase.properties as follows driver: net.snowflake.client.jdbc.SnowflakeDriver classpath: ./liquibase-snowflake-1.0.jar url:…
Eric Mamet
  • 2,681
  • 2
  • 13
  • 43
1 2 3
…
99
100