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
0 answers

Problem when initialize quartz bean in spring boot using h2

I tried to configure spring quartz in one of my project. When I run it against Oracle database it works like charm. However running it against H2 database I got error Function "EMPTY_BLOB" not found It happens when quartzScheduler bean is…
lucaskos
  • 67
  • 9
1
vote
0 answers

Liquibase and system catalogs (PostgreSQL)

I'm trying to include data from pg_catalog into my changelog files, but liquibase seems to completely ignore it. this.liquibase.generateChangeLog( buildCatalogAndSchema(this.liquibase.getDatabase()), // postgres @…
ddev
  • 65
  • 1
  • 9
1
vote
1 answer

How to use runAlways SQL changeSet

I'm testing LiquiBase, so I created first changelog to test installation and setup and it worked --liquibase formatted sql --changeset bob:1 create table test1 ( id int primary key, name varchar(255) ); what I want to test is runAlways, so…
Betlista
  • 10,327
  • 13
  • 69
  • 110
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
2 answers

How to simulate "no Internet access" in a Java unit test to test liquibase migration

I have a java web application and I use Liquibase for database migrations. I want my application to not require Internet access, but if liquibase requires a specific version of a schema file that is not included, it will try to download it. So I…
oussema
  • 322
  • 4
  • 15
1
vote
0 answers

Default Jhipster 6.7.1 Access denied for user 'root'@'localhost'

I used Jhipster 6.7.1 to generate a monolith angular/spring boot app. I chose H2 with on-disk memory for development and MySQL database for production. It all went well. I then ran jhipter mvnw command and it all seemed to be ok. Then I tested if I…
ROBlackSnail
  • 501
  • 1
  • 5
  • 20
1
vote
2 answers

Spring could not prepare statement because of a not found column

I'm working with jhipster, I got the following jdl format: I've made some modification on the domains that looks like: @Entity @Table(name = "client_account") @Cache(usage = CacheConcurrencyStrategy.NONSTRICT_READ_WRITE) public class ClientAccount…
zahma
  • 412
  • 4
  • 14
1
vote
2 answers

How to divide the changelog.yaml into subsections?

I would like to separate each change of the databaseChangeLog in YAML format into its own file (again YAML) and include/import it somehow. It should be in way such that I can use a FileSystemAccessor or ClassPathAccessor to load it again. Is there…
Dieter
  • 75
  • 5
1
vote
2 answers

liquibase and orai18n.jar

I can't run this liquibase --driver=oracle.jdbc.OracleDriver --classpath=ojdbc8.jar --url="jdbc:oracle:thin:@host:port:sid" --changeLogFile=db.xml --username=name --password=psw generateChangeLog I get an error "Unexpected error running…
Timur
  • 23
  • 1
  • 5
1
vote
1 answer

How to modify the default execution order of sql script in liquibase?

I am trying to run a bunch of sql script in the Liquibase. But, be default, liquibase executes all the scripts in the order they are placed in the directory. Is there any way by which I can alter the execution default execution of these scripts…
Pranjal Kumar
  • 65
  • 11
1
vote
1 answer

How to hide SQL scripts from Liquibase in the console?

In my Spring boot project, I am using Liquibase as version control for my database. Each time when I'm running my project I see the body of all my scripts in the console (Intellij IDEA or Terminal). Is there any possibility to remove these scripts…
Ice
  • 1,783
  • 4
  • 26
  • 52
1
vote
1 answer

Unique Constraint Violation on Hibernate @ManyToMany Relationship

I have 3 entities in my database, let's call them A, B, and C. A and B share a many-to-many relationship with one another. A has a SortedSet of Bs, but B does not reference A (no collection or w/e configured). So we have the following. // Inside…
Snowy Coder Girl
  • 5,408
  • 10
  • 41
  • 72
1
vote
1 answer

How to use diffExcludeObjects config to ignore all columns ending with id in all tables?

I want to ignore all columns that end with "_id" in all tables using liquibase maven plugin's diff command. When I run it using this config diffExcludeObjects=table:position, column:.*._id the diff ignores the columns in position that end with _id…
Kevin Liu
  • 11
  • 1
1
vote
2 answers

Liquibase 'validation only mode'

Is it possible to use Liquibase just to check the consistency of the database? We have several java application modules using the same database. We decided that only one of the modules is responsible for the execution of database migrations, while…
ABKN
  • 59
  • 5
1 2 3
…
99 100