liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: No value specified for parameter 1.

JIRA | Nathan Voxland | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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}

    JIRA | 2 years ago | Nathan Voxland
    liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: No value specified for parameter 1.
  2. 0

    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}

    JIRA | 2 years ago | Nathan Voxland
    liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: No value specified for parameter 1.
  3. 0

    Unable to update 1.0.3 db?

    GitHub | 2 years ago | ojhunt
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE commafeed.FEEDENTRYTAGS ADD CONSTRAINT fk_entry_id FOREIGN KEY (entry_id) REFERENCES commafeed.FEEDENTRIES (id): Can't create table 'commafeed.#sql-3e1_87a6' (errno: 150)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can liquibase handle a partially updated schema?

    Stack Overflow | 4 years ago | Kramer
    liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE limit ADD id serial: ERROR: column "id" of relation "limit" already exists
  6. 0

    PL/SQL and SQL script in one sqlFile with liquibase?

    Stack Overflow | 2 years ago | Gabor
    liquibase.exception.DatabaseException: ORA-06550: 4 line, 1 col: PLS-00103: Encountered the symbol: "/" [Failed SQL: BEGIN aud.someProcedure('parameter'); END; // insert into test_table(_id, value) VALUES(1, 'test') ]
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. liquibase.exception.DatabaseException

    org.postgresql.util.PSQLException: No value specified for parameter 1.

    at liquibase.statement.ExecutablePreparedStatementBase.execute()
  2. Liquibase Core
    Liquibase.update
    1. liquibase.statement.ExecutablePreparedStatementBase.execute(ExecutablePreparedStatementBase.java:79)
    2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:118)
    3. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
    4. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
    5. liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
    6. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
    7. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
    8. liquibase.Liquibase.update(Liquibase.java:200)
    8 frames
  3. org.liquibase.maven
    LiquibaseUpdate.doUpdate
    1. org.liquibase.maven.plugins.LiquibaseUpdate.doUpdate(LiquibaseUpdate.java:33)
    1 frame