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
    434
    292

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
org.postgresql.util.PSQLException: ERROR: column "this_.date" must appear in the GROUP BY clause or be used in an aggregate function Position: 296
1 matching frame hidden
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
10 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. avevia Google Groups6 days ago
    ERROR: ошибка синтаксиса в или рядом "and"
    Show stack trace
  2. Premvia Google Groups6 days ago
    Error executing DDL via JDBC Statement
    Show stack trace
  3. Premvia Google Groups6 days ago
  4. Unknown authorvia Google Groups6 days ago
    ERROR: column t1.tgconstrname does not exist Position: 113
    Show stack trace
  5. Manuel Rossettivia Google Groups1 week ago
    SQL [drop schema "test"."jsl_db"]; ERROR: syntax error at or near "." Position: 19 at org.jooq_3.10.4.POSTGRES.debug(Unknown Source)
    Show stack trace
  6. RJvia Google Groups1 week ago
    Cannot upgrade schema
    Show stack trace
  7. Eoin O'Hehirvia Google Groups1 week ago
    ERROR: syntax error at or near "$1" Position: 1
    Show stack trace
  8. jmbredalvia GitHub1 week ago
    ERROR: common column name "prefixid" appears more than once in left table
    Show stack trace
  9. savita-malaghanvia GitHub1 week ago
    Unknown command <graph>: ERROR: syntax error at or near "graph" Position: 1
    Show stack trace
  10. honyczekvia GitHub2 weeks ago
    No message found for this stack trace.
    Show stack trace