Pattern selector

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

  1. AbstractJdbc2Statement.executeUpdate() has thrown a PSQLException
    PostgreSQL JDBC Driver
    66
    90
    70
  2. QueryExecutorImpl.execute() has thrown a PSQLException
    PostgreSQL JDBC Driver
    259
    438
    293

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
org.postgresql.util.PSQLException: ERROR: syntax error at or near "$2" Position: 177
1 matching frame hidden
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
1 frame hidden

Solution

chinthana10 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. metasnwvia GitHub15 hours 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
  2. nivemahamvia GitHub19 hours 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
  3. rbygravevia GitHub3 days 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
  4. kwootvia GitHub4 days 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
  5. kwootvia GitHub4 days ago
    could not delete: [org.navalplanner.business.advance.entities.AdvanceType#150187]
    Show stack trace
  6. Павел Кураевvia Google Groups5 days ago
    ERROR: duplicate key value violates unique constraint "druid_pendingsegments_pkey" Detail: Key (id)=(dsp_traf_supervisor_2018-10-12T11:15:00.000Z_2018-10-12T11:30:00.000Z_2018-10-12T11:15:00.092Z_12) already exists. [statement:"INSERT INTO druid_pendingSegments (id, dataSource, created_date, start, \"end\", sequence_name, sequence_prev_id, sequence_name_prev_id_sha1, payload) VALUES (:id, :dataSource, :created_date, :start, :end, :sequence_name, :sequence_prev_id, :sequence_name_prev_id_sha1, :payload)", located:"INSERT INTO druid_pendingSegments (id, dataSource, created_date, start, \"end\", sequence_name, sequence_prev_id, sequence_name_prev_id_sha1, payload) VALUES (:id, :dataSource, :created_date, :start, :end, :sequence_name, :sequence_prev_id, :sequence_name_prev_id_sha1, :payload)", rewritten:"INSERT INTO druid_pendingSegments (id, dataSource, created_date, start, "end", sequence_name, sequence_prev_id, sequence_name_prev_id_sha1, payload) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", arguments:{ positional:{}, named:{sequence_prev_id:'',payload:[123, 34, 100, 97, 116, 97, 83, 111, 117, 114, 99, 101, 34, 58, 34, 100, 115, 112, 95, 116, 114, 97, 102, 95, 115, 117, 112, 101, 114, 118, 105, 115, 111, 114, 34, 44, 34, 105, 110, 116, 101, 114, 118, 97, 108, 34, 58, 34, 50, 48, 49, 56, 45, 49, 48, 45, 49, 50, 84, 49, 49, 58, 49, 53, 58, 48, 48, 46, 48, 48, 48, 90, 47, 50, 48, 49, 56, 45, 49, 48, 45, 49, 50, 84, 49, 49, 58, 51, 48, 58, 48, 48, 46, 48, 48, 48, 90, 34, 44, 34, 118, 101, 114, 115, 105, 111, 110, 34, 58, 34, 50, 48, 49, 56, 45, 49, 48, 45, 49, 50, 84, 49, 49, 58, 49, 53, 58, 48, 48, 46, 48, 57, 50, 90, 34, 44, 34, 115, 104, 97, 114, 100, 83, 112, 101, 99, 34, 58, 123, 34, 116, 121, 112, 101, 34, 58, 34, 110, 117, 109, 98, 101, 114, 101, 100, 34, 44, 34, 112, 97, 114, 116, 105, 116, 105, 111, 110, 78, 117, 109, 34, 58, 49, 50, 44, 34, 112, 97, 114, 116, 105, 116, 105, 111, 110, 115, 34, 58, 48, 125, 125],start:'2018-10-12T11:15:00.000Z',end:'2018-10-12T11:30:00.000Z',id:'dsp_traf_supervisor_2018-10-12T11:15:00.000Z_2018-10-12T11:30:00.000Z_2018-10-12T11:15:00.092Z_12',created_date:'2018-10-12T11:15:23.418Z',dataSource:'dsp_traf_supervisor',sequence_name:'index_kafka_dsp_traf_supervisor_827bb8282302a59_0',sequence_name_prev_id_sha1:'46CF081194E631F94FD6879CEF3C3A3AF4C5068F'},
    Show stack trace
  7. RJvia Google Groups6 days ago
    Cannot apply SQL DROP INDEX patch_set_approvals_openByUser
    Show stack trace
  8. Prem Anandvia Google Groups1 week ago
    [src.CleanDiskProcess:220 - :3] -- org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace
  9. lakshmikantha reddyvia Google Groups1 week ago