Clickhouse latest version 24.4.1 is not working with flyway

DebaduttaP98

When I use flyway with latest click house I see below exceptions, please someone help me out:

Caused by: org.flywaydb.core.api.FlywayException: Unsupported Database: ClickHouse 24.4

at org.flywaydb.core.internal.database.DatabaseFactory.createDatabase(DatabaseFactory.java:218) ~[flyway-core-5.1.1.jar:?]

at org.flywaydb.core.internal.database.DatabaseFactory.createDatabase(DatabaseFactory.java:86) ~[flyway-core-5.1.1.jar:?]

at org.flywaydb.core.Flyway.execute(Flyway.java:1227) ~[flyway-core-5.1.1.jar:?]

at org.flywaydb.core.Flyway.migrate(Flyway.java:910) ~[flyway-core-5.1.1.jar:?]

at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]

at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]

at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]

at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1930) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1872) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:209) ~[spring-beans-5.3.34.jar:5.3.34]

at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.resolveBeanReference(ConfigurationClassEnhancer.java:362) ~[spring-context-5.3.34.jar:5.3.34]

at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:334) ~[spring-context-5.3.34.jar:5.3.34]

at com.netscout.pfsone.config.ApplicationConfig$$EnhancerBySpringCGLIB$$1ee44d61.flywayClickHouse(<generated>) ~[classes/:6.5.1-SNAPSHOT]

at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]

at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) ~[?:?]

at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]

at java.lang.reflect.Method.invoke(Method.java:568) ~[?:?]

DanC

Hi @DebaduttaP98

Can I ask what version of Flyway you're running?

AlistairW

If you are using the Flyway API then have you included the Clickhouse dependency in your project  (https://documentation.red-gate.com/fd/clickhouse-database-233439843.html) ? This pinned issue describes the reasoning but Clickhouse support was released afterwards so isn't included in the list: https://github.com/flyway/flyway/issues/3780