liquibase.exception.DatabaseException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • GitHub comment 3321#205684486
    via GitHub by adam-ho
    ,
  • GitHub comment 1#219251094
    via GitHub by ThomasBassa
    ,
  • When I generate the SQL (using updateSQL goal), I get an incorrect CREATE INDEX statement: {code:sql} CREATE INDEX DOCTEST.DT_IND1 ON DOCTEST.DUMMYTABLE(BEGINDAT,ENDDAT) IN "INDTBS01"; {code} Part of my changeset: {code:xml} <changeSet author="autor (generated)" id="1481017937614-10"> <createTable catalogName="DOCTEST" schemaName="DOCTEST" tablespace="DATATBS01" tableName="DUMMYTABLE"> <column name="ID" type="DECIMAL(18)"> <constraints nullable="false"/> </column> <column name="BEGINDAT" type="timestamp(6)"/> <column name="ENDDAT" type="timestamp(6)"/> </createTable> </changeSet> <changeSet author="autor (generated)" id="1481017937614-91"> <addPrimaryKey columnNames="ID" constraintName="SQL161206095945030" tableName="DUMMYTABLE"/> </changeSet> <changeSet author="autor (generated)" id="1481017937614-163"> <createIndex catalogName="DOCTEST" schemaName="DOCTEST" tablespace="INDTBS01" indexName="DT_IND1" tableName="DUMMYTABLE"> <column name="BEGINDAT"/> <column name="ENDDAT"/> </createIndex> </changeSet> {code} Error: {code:none} liquibase.exception.MigrationFailedException: Migration failed for change set /changelog.xml::1481017937614-163::autor (generated): Reason: liquibase.exception.DatabaseException: The statement or command was not processed because the following clause is not supported in the context where it is used: "IN".. SQLCODE=-109, SQLSTATE=42601, DRIVER=4.16.53 SQL Code: -109, SQL State: 42601, DRIVER=4.16.53 [Failed SQL: CREATE INDEX DOCTEST.DT_IND1 ON DOCTEST.DUMMYTABLE(BEGINDAT, ENDDAT) IN "INDTBS01"] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:619) {code} For the full stackstace, see attachment. Also affects Liquibase-Runner plugin in jenkins (v1.3.0)
    via by K.K,
  • two relations on one entity, jhipster
    via Stack Overflow by Juan Manuel Lopez
    ,
    • liquibase.exception.DatabaseException: java.sql.SQLException: Invalid SQL statement or JDBC escape, terminating ''' not found. at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1221) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1204) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)

    Users with the same issue

    tvrmsmith
    1 times, last one,
    Malcshour
    13 times, last one,