LocalDateTime cast exception

General Discussion
1

I am getting error Error setting up or running Liquibase:
java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.lang.String
when executing mvn liquibase:update.

Migration is building on 4 sql files included in ChangeLog.

If these files executed in MySQL Workbench - everything is ok.

Caused by: java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.lang.String
at liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets (StandardChangeLogHistoryService.java:324)
at liquibase.changelog.AbstractChangeLogHistoryService.upgradeChecksums (AbstractChangeLogHistoryService.java:65)
at liquibase.changelog.StandardChangeLogHistoryService.upgradeChecksums (StandardChangeLogHistoryService.java:292)
at liquibase.Liquibase.checkLiquibaseTables (Liquibase.java:1788)
at liquibase.Liquibase.lambda$update$1 (Liquibase.java:232)
at liquibase.Scope.lambda$child$0 (Scope.java:160)
at liquibase.Scope.child (Scope.java:169)
at liquibase.Scope.child (Scope.java:159)
at liquibase.Scope.child (Scope.java:138)
at liquibase.Liquibase.runInScope (Liquibase.java:2277)
at liquibase.Liquibase.update (Liquibase.java:215)
at liquibase.Liquibase.update (Liquibase.java:201)
at liquibase.Liquibase.update (Liquibase.java:532)
at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate (LiquibaseUpdate.java:33)
at org.liquibase.maven.plugins.AbstractLiquibaseUpdateMojo.performLiquibaseTask (AbstractLiquibaseUpdateMojo.java:30)
at org.liquibase.maven.plugins.AbstractLiquibaseMojo.lambda$null$0 (AbstractLiquibaseMojo.java:446)
at liquibase.Scope.lambda$child$0 (Scope.java:160)
at liquibase.Scope.child (Scope.java:169)
at liquibase.Scope.child (Scope.java:159)
at liquibase.Scope.child (Scope.java:138)
at org.liquibase.maven.plugins.AbstractLiquibaseMojo.lambda$execute$1 (AbstractLiquibaseMojo.java:372)
at liquibase.Scope.lambda$child$0 (Scope.java:160)
at liquibase.Scope.child (Scope.java:169)
at liquibase.Scope.child (Scope.java:159)
at liquibase.Scope.child (Scope.java:138)
at liquibase.Scope.child (Scope.java:222)
at liquibase.Scope.child (Scope.java:226)
at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute (AbstractLiquibaseMojo.java:306)
at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:210)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156)
at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117)
at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)
at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)
at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305)
at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)
at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)
at org.apache.maven.cli.MavenCli.execute (MavenCli.java:957)
at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:289)
at org.apache.maven.cli.MavenCli.main (MavenCli.java:193)
at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke (Method.java:498)
at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)
at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)
at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)
at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)

2

I’ve remodeled sql to xml and repeated update.

Appears that same mistake happens if multiple changesets are applied to partially completed dbchangelog.xml

If I drop every table and repeat update - everything seems to work fine.

3

Have the same problem. Have you find a solutionor root of this problem? Should you have, please inform us here

4

I see this when updating the version of mysql-connector-java. Not getting it on v8.0.20 - v8.0.22 but v8.0.23 - v8.0.33 both get this error.

Haven’t tried updating liquibase yet, because that might lead to new problems.

Looks like this is: ClassCastException on moving to mysql-connector-java version 8.0.23 · Issue #1639 · liquibase/liquibase · GitHub