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

Stack Overflow | stickfigure | 8 months 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

    How to use Postgres JSON operators in a WHERE condition with jOOQ?

    Stack Overflow | 8 months ago | stickfigure
    org.postgresql.util.PSQLException: No value specified for parameter 1.
  2. 0

    Postgres connectivity via JDBC: org.postgresql.util.PSQLException: ERROR: relation "prescriptions" does not exist

    Stack Overflow | 10 months ago | xtro
    org.postgresql.util.PSQLException: ERROR: relation "prescriptions" does not exist Position: 29
  3. 0

    How to resolve "Caused by: org.postgresql.util.PSQLException: ERROR: relation "employee" does not exist Position: 13" error?

    Stack Overflow | 9 months ago | TechGuy
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Unable to execute command [create table HibernateDemo.Employee (id int4 not null, firstName varchar(255), lastName varchar(255), primary key (id))]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spring JDBC DataSource Initializer fails for schema with stored procedure definitions

    GitHub | 9 months ago | jhvhs
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Tomcat.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceInitializer': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #11 of URL [file:/Users/pivotal/workspace/db_initialize_fail/build/resources/main/schema.sql]: CREATE FUNCTION count_clients() RETURNS integer LANGUAGE plpgsql AS $$begin select count(*) from clients; nested exception is org.postgresql.util.PSQLException: ERROR: unterminated dollar-quoted string at or near "$$begin select count(*) from clients" Position: 69

  1. kjhdofjosvs 4 times, last 3 months ago
  2. archenroot 1 times, last 5 months ago
  3. serious2monkeys 19 times, last 5 months ago
  4. iferca 18 times, last 4 weeks ago
  5. johnxfly 1 times, last 2 months ago
1 more registered users
17 unregistered visitors
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. org.postgresql.util.PSQLException

    No value specified for parameter 1.

    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet()
  2. PostgreSQL JDBC Driver
    QueryExecutorImpl.execute
    1. org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:228)
    2. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:163)
    2 frames
  3. org.postgresql.jdbc
    PgStatement.execute
    1. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:622)
    2. org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:472)
    3. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:465)
    3 frames
  4. jOOQ
    AbstractQuery.execute
    1. org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:194)
    2. org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:269)
    3. org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:348)
    3 frames