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.

  • I have a Liquibase 2.x style change set with the following configuration: {code} <renameColumn tableName="my_table" oldColumnName="my_column_old" newColumnName="my_column_new" columnDataType="text"/> {code} This change set worked properly against MySQL using Liquibase 2.x. Running this change set against a MySQL database using Liquibase 3.x, I encounter the following error: {code} [INFO] ChangeSet schema/my.changelog.xml::my-changeset::jduke ran successfully in 32ms [ERROR] Change Set my.changelog.xml::my-changeset::jduke failed. Error: Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'clob' at line 1 liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'clob' at line 1 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1341) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1325) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:28) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:135) {code} It seems that Liquibase is incorrectly mapping the 'text' data type to 'clob', when it should be using 'text' for MySQL, as it did in 2.x. I have verified I am using a MySQLDatabase object. Is this a bug, or am I missing something?
    via by Jason Duke,
  • I have a Liquibase 2.x style change set with the following configuration: {code} <renameColumn tableName="my_table" oldColumnName="my_column_old" newColumnName="my_column_new" columnDataType="text"/> {code} This change set worked properly against MySQL using Liquibase 2.x. Running this change set against a MySQL database using Liquibase 3.x, I encounter the following error: {code} [INFO] ChangeSet schema/my.changelog.xml::my-changeset::jduke ran successfully in 32ms [ERROR] Change Set my.changelog.xml::my-changeset::jduke failed. Error: Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'clob' at line 1 liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'clob' at line 1 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1341) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1325) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:28) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:135) {code} It seems that Liquibase is incorrectly mapping the 'text' data type to 'clob', when it should be using 'text' for MySQL, as it did in 2.x. I have verified I am using a MySQLDatabase object. Is this a bug, or am I missing something?
    via by Jason Duke,
  • Unable to update 1.0.3 db?
    via GitHub by ojhunt
    ,
  • Reported via email: Using this statement to insert the binary data: {code} <insert tableName="webtools_file"> <column name="db_id" valueNumeric="275" /> <column name="db_created" /> <column name="db_updated" /> <column name="db_version" valueNumeric="1" /> <column name="content" valueBlobFile="icons/8f13b0edb57b156bf807f0e329afc76c.png" /> <column name="filesize" valueNumeric="5867" /> <column name="filename" value="8f13b0edb57b156bf807f0e329afc76c.png" /> <column name="hash" value="8f13b0edb57b156bf807f0e329afc76c" /> <column name="mimetype" value="image/png" /> </insert> {code} This works perfectly fine in Liquibase 3.2.3, but in Liquibase 3.3.x, I get this exception: {code} liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: No value specified for parameter 1. at liquibase.statement.ExecutablePreparedStatementBase.execute(ExecutablePreparedStatementBase.java:79) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:118) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:33) … Caused by: org.postgresql.util.PSQLException: No value specified for parameter 1. at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:228) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:245) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413) at liquibase.statement.ExecutablePreparedStatementBase.execute(ExecutablePreparedStatementBase.java:77) {code}
    via by Nathan Voxland,
    • liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE my_database.my_table CHANGE my_column_old my_column_new clob: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'clob' at line 1 at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:56) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:98) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1341) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1325) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:343) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:28) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.update(Liquibase.java:135)

    Users with the same issue

    davidvanlaatum
    1 times, last one,