Using Liquibase 3.3.2 with Vertica 7.1 : java.lang.NoSuchMethodError: liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables

Hello,

I’m trying to use the new liquibase version 3.3.2 with vertica
extension 1.2 (got from here :
https://liquibase.jira.com/wiki/display/CONTRIB/Liquibase+Vertica+Extension)
but I have the following exception :

DEBUG
1/13/15 10:47 AM: liquibase: Connected to
VDDBADEV2@jdbc:vertica://vip-farm-f5-dv_shr00:5433/DV_SHR00
DEBUG
1/13/15 10:47 AM: liquibase: Setting auto commit to false from
true
DEBUG 1/13/15 10:47 AM: liquibase: Computed checksum for
1421142460847 as 14c3e43bd079e3a70467fbcc7b24a2ae
Unexpected
error running Liquibase: liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/util/List;


SEVERE 1/13/15 10:47 AM: liquibase:
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/util/List;
java.lang.NoSuchMethodError:
liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData.getTables(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/util/List;

at
liquibase.ext.vertica.snapshot.TableSnapshotGeneratorVertica.snapshotObject(TableSnapshotGeneratorVertica.java:46)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:60)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:63)

at
liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:50)

at
liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:163)

at
liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:60)

at
liquibase.snapshot.DatabaseSnapshot.(DatabaseSnapshot.java:37)

at
liquibase.snapshot.JdbcDatabaseSnapshot.(JdbcDatabaseSnapshot.java:25)

at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:126)

at
liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:134)

at
liquibase.snapshot.SnapshotGeneratorFactory.has(SnapshotGeneratorFactory.java:88)

at
liquibase.snapshot.SnapshotGeneratorFactory.hasDatabaseChangeLogLockTable(SnapshotGeneratorFactory.java:166)

at
liquibase.lockservice.StandardLockService.hasDatabaseChangeLogLockTable(StandardLockService.java:139)

at
liquibase.lockservice.StandardLockService.init(StandardLockService.java:85)

at
liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:188)

at
liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:154)

at liquibase.Liquibase.update(Liquibase.java:186)
at
liquibase.integration.commandline.Main.doMigration(Main.java:1044)

at
liquibase.integration.commandline.Main.run(Main.java:175)

at liquibase.integration.commandline.Main.main(Main.java:94)



Is there any new version of the vertica extension incoming soon,
compatible with 3.3.2 of Liquibase ?



Regards,

Mohamed.






The vertica extension is managed separately from Liquibase. It may work best to file an issue at https://github.com/cohenjo/liquibase-vertica

Nathan