MEDIARITHMICS / liquibase-clickhouse

Apache License 2.0
43 stars 39 forks source link

Transactions are not supported #22

Open VadimSimonov opened 2 years ago

VadimSimonov commented 2 years ago

Hello everyone. I'm trying to use your library on a sprig boot(2.5.7) application. This error happens

error:

[app] Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set db/changesets/1/createTables-clickhouse.yml::create-database::1:
[app]      Reason: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLFeatureNotSupportedException: **Transactions are not supported**

It looks like your extension is not being picked up.

application.yml

spring:
  liquibase:
    url: "jdbc:clickhouse://${ip}:${port}"
    driverClassName: "ru.yandex.clickhouse.ClickHouseDriver"
    change-log: classpath:db/liquibase-click-changelog.yml

liquibase-click-changelog.yml

databaseChangeLog:
  - include:
      file: changesets/1/createTables-clickhouse.yml
      relativeToChangelogFile: true

createTables-clickhouse.yml

databaseChangeLog:
  - changeSet:
      id: 1
      author: 1
      changes:
        - sql: create database if not exist dbname;

gradle:

    implementation 'org.liquibase:liquibase-core:4.3.5'
    implementation group: 'com.mediarithmics', name: 'liquibase-clickhouse', version: '0.7.2'
lavoiemathieu commented 2 years ago

@VadimSimonov I don't if you were able to solve your issue but it looks like the JDBC connection 0.3.1 works but not the 0.3.2.

ru.yandex.clickhouse:clickhouse-jdbc:0.3.1 -> Works ru.yandex.clickhouse:clickhouse-jdbc:0.3.2 -> Does not work