Pattern selector

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

  1. MapFacadeBean.commitTransaction() has thrown a PersistenceException
    Unsorted
    0
    0
    0
  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: la columna «numeronhc» fue especificada más de una vez Position: 52
1 matching frame hidden
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1829)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
67 frames 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. Uafindervia GitHub2 days ago
    could not execute statement
    Show stack trace
  2. nstewartvia GitHub3 days ago
    org.postgresql.util.PSQLException: ERROR: relation "config_profile" does not exist
    Show stack trace
  3. Jangamvia GitHub3 days ago
    ERROR: column "to_address" of relation "transactions" does not exist Position: 87
    Show stack trace
  4. BenDolvia GitHub3 days 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 GitHub4 days ago
    ERROR: invalid input syntax for integer: "5152.0" Where: COPY kepler, line 2, column teff: "5152.0"
    Show stack trace
  6. metasnwvia GitHub5 days 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 GitHub6 days 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 GitHub1 week 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 week 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