unbroken-dome / liquibase-orientdb Goto Github PK

Hello, i tried to use your library (thank you for it), and get an error when run liquibase:update task:

Error setting up or running Liquibase: liquibase.exception.DatabaseException:
Error while executing command [Failed SQL: CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]:
Cannot find a command executor for the command request: sql.CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED datetime, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))

Have you ever got this error or something like this?
I guess that the problem in liquibase algorithms, they try to create tables in database, but database doesn't understand this syntax.

I hope for your help, thank you.

Please compare liquibase-orientdb.xsd

<xsd:attribute name="name" type="tns:PropertyQualifiedName" use="required" />

with DropPropertyChange.java

    @SerializedField(description = "The name of the class that contains the property")
    @NotNull
    @Size(min = 1)
    public String getClassName() {
        return className;
    }

    @SerializedField(description = "The name of the property")
    @NotNull
    @Size(min = 1)
    public String getPropertyName() {
        return propertyName;
    }

Currently running Liquibase dropAll with the plugin on an OrientDB fails because the DROP TABLE statements are sent to OrientDB directly. OrientDB doesn't understand DROP TABLE; these statements should be mapped to DROP CLASS instead.

The plugin should provide a custom SqlGenerators that maps DropTableStatement to a DropClassSql, similar to what OrientCreateTableSqlGenerator does for CreateTableStatement.

There are possibly other types of DB objects that need to be dropped correctly.