Questions tagged [liquibase-sql]
113 questions
0
votes
1 answer
How to create Liquibase changeset for below Postgres index creation statement - "using btree"
create index if not exists department_index
on department using btree (department_id);
How can I create a Liquibase changeset for the above Postgresql? I have to use "using btree" feature in order to attain the desired performance,
0
votes
1 answer
liquibase sql migration issue
I am writing 1 PostgreSQL function for some operation.
Writing SQL migration for that function but facing formatting error as liquibase is not able to recognize some portion.
Function Liquibase Migration:
CREATE OR REPLACE FUNCTION schema.fncn(trId…
user3145373 ツ
- 7,858
- 6
- 43
- 62
0
votes
1 answer
Liquibase insert select where not exists
I want to insert into table1 multiple rows from table2. The problem is that I have a field of same name in table2 and table1 and I don't want to insert data if there's already a record with same value in this field. Now I have something like…
Arzybek
- 547
- 2
- 6
- 27
0
votes
1 answer
Liquibase insert select multiple rows postgres
I want to insert into table1 multiple rows from table2. The problem is that I have some fields in table1 that I want to compute, and some rows that I want to select from table2. For example something like this:
insert into table1 (id, selectField1,…
Arzybek
- 547
- 2
- 6
- 27
0
votes
1 answer
How to continue execution of Liquibase script even though there is error thrown?
I'm using MySQL database. I'm giving call to an stored procedure for 3 times to insert 3 records. following is the example for the same.
Aԃιƚყα Gυɾαʋ
- 107
- 1
- 15
0
votes
1 answer
mvn liquibase:generateChangeLog not working with an URL problem
I don't understand something with Liquibase and Spring Boot.
When I run my spring boot project with : mvn spring-boot:run
My changelog-v1.0.xml create a table and add two users inside my table user. So my liquibase is linked to my mySQL Database…
LelouchXV
- 143
- 1
- 8
0
votes
1 answer
Liquibase with Maven using Teradata
I am getting the following error, while running the command: mvn liquibase:update
liquibase.exception.databaseexception:connection could not be created to jdbc:teradata://org.sys.db.com/database=sample_DEV with driver com.teradata.jdbc.TestDriver…
0
votes
0 answers
How to setup Liquibase to use custom SequenceStyleGenerator
so I have custom IdGenerator like that:
@Service
public class IdGenerator extends SequenceStyleGenerator {
private final SequenceRepository sequenceRepository;
public IdGenerator(SequenceRepository sequenceRepository) {
…
WildTigerrr
- 38
- 9
0
votes
0 answers
Update database after creating entitys
I'm having a problem. Every time I update the JDL file by adding some entity or relationship, the database is not updated. And I think this is what causes that when I go to make a GET request, I get an "Internal Server Error". What I want is that…
Franco Mendoza
- 37
- 1
- 1
- 5
0
votes
1 answer
Liquibase labels
I was playing around with liquibase (SQL syntax) and got stuck with labels. I have them in my changelog, but the 'labels' column in the changelog table is empty. Because of that, I can't run any command where labels are involved.
I saw an example…
Dmitry
- 321
- 1
- 3
- 10
0
votes
1 answer
liquibase failOnError:false runAlways:false not working
It's possible not to run again an SQL file which fails in the past with liquibase?
I tried with failOnError:false runAlways:false but no DATABASECHANGELOG entry is made.
viglu
- 125
- 1
- 9
0
votes
0 answers
Liquibase inserting with CSV file with ID - identity has an exception Column "ID" contains null values; SQL statement:
I tested a lot of time and could not resolve one problem. I have a sql changelog for creating tables with changesets inside it. The column Id is Identity, db = h2. I insert data through CSV file and everytime when I try I have a null exception in Id…
0
votes
1 answer
Liquibase SQL Changeset Cannot Load CSV File : FileNotFoundException
Using a SQL style approach to Liquibase changesets (which is our codestyle, we don't use XML) I am trying to load an CSV file using the following SQL changeset
SQL
-- changeset user:insert-prices-data-temp-table
LOAD DATA LOCAL INFILE…
tomaytotomato
- 3,788
- 16
- 64
- 119
0
votes
0 answers
Insert with liquibase failing on H2 with Table not found during startup
I am using liquibase 4.3.3 to insert data to H2 DB using yaml changeset. But, when I try to start the server I get table not found while inserting even though the table exists. But, if I use the generated insert statement and disable liquibase and…
DEEPAK MURTHY
- 13
- 1
- 5
0
votes
1 answer
Exception for master.yaml while running Liquibase springboot application
Ref - LiquiBase problem , class path resource [db/changelog/db.changelog-master.yaml] cannot be resolved to URL because it does not exist
I am facing similar problem as above, however proposed solution is already there in my…
Angelina
- 1
- 1