Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. DelegatingPreparedStatement.executeQuery() has thrown a PSQLException
    Commons DBCP
    8
    11
    49
  2. QueryExecutorImpl.execute() has thrown a PSQLException
    PostgreSQL JDBC Driver
    259
    440
    293

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 2082
1 matching frame hidden
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
3 frames hidden

Solution

chinthana11 months ago

Upgrade the database driver to the latest and check.

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.3-1101-jdbc41</version>
</dependency>

Replace version with the latest driver version.

Check the source of this solution for more info

External results for this pattern (10)

  1. Uafindervia GitHub3 weeks ago
    could not execute statement
    Show stack trace
  2. nstewartvia GitHub3 weeks ago
    org.postgresql.util.PSQLException: ERROR: relation "config_profile" does not exist
    Show stack trace
  3. Jangamvia GitHub3 weeks ago
    ERROR: column "to_address" of relation "transactions" does not exist Position: 87
    Show stack trace
  4. BenDolvia GitHub3 weeks ago
    PreparedStatementCallback; SQL [SELECT S.PRIMARY_ID, S.SESSION_ID, S.CREATION_TIME, S.LAST_ACCESS_TIME, S.MAX_INACTIVE_INTERVAL, SA.ATTRIBUTE_NAME, SA.ATTRIBUTE_BYTES FROM SPRING_SESSION S LEFT OUTER JOIN SPRING_SESSION_ATTRIBUTES SA ON S.PRIMARY_ID = SA.SESSION_PRIMARY_ID WHERE S.SESSION_ID = ?ERROR: invalid byte sequence for encoding "UTF8": 0x00; nested exception is org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00
    Show stack trace
  5. dorisjleevia GitHub3 weeks ago
    ERROR: invalid input syntax for integer: "5152.0" Where: COPY kepler, line 2, column teff: "5152.0"
    Show stack trace
  6. metasnwvia GitHub3 weeks ago
    ERROR: insert or update on table "r_request" violates foreign key constraint "c_bpartner_rrequest" Detail: Key (c_bpartner_id)=(1000541) is not present in table "c_bpartner".
    Show stack trace
  7. nivemahamvia GitHub3 weeks ago
    could not execute statement; SQL [n/a]; constraint [fk_subject_user_id]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace
  8. rbygravevia GitHub4 weeks ago
    Query threw SQLException:ERROR: operator does not exist: uuid = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 51 Bind values:[Array[1]={9cdd9e79-2e1d-48d6-8a11-11ab1d39dc2c}] Query was:select t0.id from child_sibling t0 where child_id = any(?)
    Show stack trace
  9. kwootvia GitHub1 month ago
    could not delete: [org.navalplanner.business.orders.entities.OrderLine#3700]; nested exception is org.hibernate.exception.ConstraintViolationException: could not delete: [org.navalplanner.business.orders.entities.OrderLine#3700]
    Show stack trace