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

Stack Overflow | stickfigure | 5 months ago
  1. 0

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

    Stack Overflow | 5 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 | 6 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 | 6 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 | 6 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. archenroot 1 times, last 1 month ago
  2. serious2monkeys 19 times, last 1 month ago
  3. kjhdofjosvs 57 times, last 4 days ago
  4. smyrgeorge 1 times, last 4 months ago
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