org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 12

java.net | 2 weeks ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Bug 5315 – Broken PostgreSQL Support in SE mode

    java.net | 2 weeks ago
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 12
  2. 0

    How to add blocks of text with punctuations in PostgreSQL

    Stack Overflow | 3 years ago | user2820488
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "life" Position: 68
  3. 0

    I need to add values into postresql in java,

    Stack Overflow | 3 years ago | topal
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "(" Position: 157
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    postgresql - SET ROLE via parameterized query - Database Administrators Stack Exchange

    stackexchange.com | 8 months ago
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 10
  6. 0

    JDBC query fails, though it runs from pgAdmin

    Stack Overflow | 5 years ago | Zsolt János
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$2" Position: 177

  1. silex 5 times, last 3 months ago
20 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

    ERROR: syntax error at or near "$1" Position: 12

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeUpdate
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
    6 frames
  3. test
    Main.main
    1. test.Main.main(Main.java:21)[2]
    1 frame