Stack Overflow
Stack Overflow

Questions tagged [liquibase-sql]

113 questions
2
votes
0 answers

How to pass command line parameter to liquibase.properties file

I have a file liquibase.properties with below contents driver: com.microsoft.sqlserver.jdbc.SQLServerDriver classpath: ./sqljdbc4-2.0.jar url: jdbc:sqlserver://localhost:1433;databaseName=staticDB username: sa password: admin@123 changeLogFile:…
Eddie
  • 581
  • 3
  • 11
  • 20
2
votes
0 answers

Creating a new PostgreSQl database

I am trying to create a new PostgreSQL database using Liquibase. I am using this syntax:
Tamar
  • 145
  • 4
  • 15
2
votes
1 answer

How to execute a CustomSqlChange manually

I'm writing a CustomSqlChange for the first time and want to test the outcome by running it on my current database. Of course I could start up the application and execute all change sets via liquibase (including the one that executes my…
mgessenich
  • 21
  • 2
1
vote
0 answers

Liquibase Error : Cannot load service: liquibase.hub.HubService: Provider liquibase.hub.core.StandardHubService could not be instantiated

I am using liquibase in my quarkus application, where I want to perform a simple operation to execute a .sql file through the master changeLog.xml but upon running the same I am getting the below error: "Quarkus Main Thread", "message" : "Cannot…
Xwin
  • 103
  • 5
  • 16
1
vote
1 answer

How to execute Set escape \; in liquibase

There are several insert sql statements which have \ in them. Originally the statements were written for manual execution from sql developer. So SET ESCAPE ; would work and the insert scripts also would be inserting the values as per…
Harsh
  • 11
  • 1
1
vote
1 answer

Liquibase with Spring Boot and SQL Server throwing error NoClassDefFOundError for class SnowflakeDatabase

My Spring Boot application is using local SQL server database is failing on startup with error below. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource…
Rumaiz Mohomed
  • 23
  • 6
1
vote
1 answer

liquibase update data based on existing column

Here, I am new to liquibase and I have a scenario where I need to add a new column to the existing table and have the value of this column based on existing column. However I was able to add column but I couldn't find a way to set default value for…
Manish Visave
  • 130
  • 9
1
vote
1 answer

Liquibase 4.8.0 upgrade causing issue with one of the existing change sets

I have a changeset which does not get executed after I have upgrade liquibase-core to 4.8.0 version. I am using postgres DB here. Fails with below error: caused by: liquibase.exception.LiquibaseException:…
Chaitanya DC
  • 11
  • 1
1
vote
2 answers

Liquibase GenerateChangeLog doesnt include schemaName in the changelog file

I am using the following command to generate the change log liquibase --schemas=test_schema --changelog-file=changelog.xml generateChangeLog My liquibase.properties file is following: url: jdbc:postgresql://xx.xxx.xx.xx:5432/test_db driver:…
Sam
  • 161
  • 1
  • 9
1
vote
1 answer

Liquibase create/alter DB user

I want to create and alter DB user using Liquibase. Following are the SQL queries to do so for Oracle DB. change password: ALTER USER ADMIN IDENTIFIED BY ${user.password}; create user: CREATE USER appuser IDENTIFIED BY ${user.password}; I want to…
Prometheus
  • 549
  • 1
  • 7
  • 18
1
vote
2 answers

Changeset requirement to identify unique change to execute by liquibase

I came across the below document for liquibase but confused about the wording on how it identifies the unique change. https://docs.liquibase.com/concepts/basic/changeset.html It says: 'If it has been run, the changeset will be skipped unless there…
bhagya
  • 41
  • 4
1
vote
2 answers

How to recalculate checksums without re-running the statements in liquibase?

We were upgrade our liquibase from 1.9.0.0 to 3.6.3. When running migration MD5SUM for 3.6.3 was updated but it was trying to re-run the previously executed changesets which were executed with liquibase 1.9.0.0. How do i run only updating checksum…
DilliBabu S
  • 53
  • 1
  • 9
1
vote
1 answer

Liquibase checksum validation failed when running via Jenkins but not from terminal

I am running below command from Linux(Centos) terminal, mvn --settings /home/centos/.m2/jenkins/liquibase-settings.xml -e resources:resources -Pdev -Dliquibase.promptOnNonLocalDatabase=false -Dliquibase.defaultSchemaName=MYDEV_SCHEMA…
karthikeayan
  • 4,291
  • 7
  • 37
  • 75
1
vote
1 answer

Liquibase - Get Altered Row Count Output from SQL Changelog

I am wondering if there is a way to log the result output of insert/update/delete commands for example if I run the below, I would like to find the "1 row affected" output which I would otherwise see if I ran in SQL Server Management…
flerngobot
  • 616
  • 1
  • 9
  • 30
1
vote
1 answer

How do I specify validchecksum to any in liquibase formatted sql?

I have run into an issue with liquibase. So , I made a mistake in my sql commands in one of the changesets. Now whenever I try to upgrade my deployment , the upgrade is failing due to wrong checksum. So I thought of doing the validCheckSum : ANY…
darthsithius
  • 73
  • 2
  • 10
1
2
3 4 5 6 7 8