Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

  1. ,
    Expert tip

    Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

  2. ,
    via stackoverflow.com by Unknown author

    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.

Solutions on the web

via Google Groups by Seckin Pulatkan, 1 year ago
ERROR: column "t1.create_timestamp" must appear in the GROUP BY clause or be used in an aggregate function Position: 129 Error Code: 0 Call: SELECT t0.service_name, t0.departure_timestamp, t0.departure_station, t0.arrival_station, t1
via Stack Overflow by user3110615
, 2 years ago
ERROR: operator does not exist: bigint = record Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 160 Error Code: 0 Call: SELECT ID, amount, comment, created_date, currency
via Stack Overflow by Olivier J.
, 2 years ago
", "PKHASHCODE", "SCHEDULE", "STATE" FROM "EJB__TIMER__TBL" WHERE (("OWNERID" = ?) AND ("STATE" = ?)) bind =&gt; [2 parameters bound] Query: ReadAllQuery(name="findTimersByOwnerAndState" referenceClass=TimerState sql="SELECT "TIMERID", "APPLICATIONID
via Stack Overflow by App Work
, 2 years ago
ERROR: relation "vmb_mails_seq" does not exist Position: 16 Error Code: 0 Call: select nextval('vmb_mails_seq') Query: ValueReadQuery(sql="select nextval('vmb_mails_seq')")
org.postgresql.util.PSQLException: ERROR: column"t1.create_timestamp" must appear in the GROUP BY clause or be used in anaggregate function Position: 129Error Code: 0Call: SELECT t0.service_name, t0.departure_timestamp, t0.departure_station,t0.arrival_station, t1.inventory_class, date_part(?,age(t1.create_timestamp)), COUNT(t1.ID), AVG(t1.original_price) FROM segmentt0, item t1 WHERE ((((t1.product_type = ?) AND (t0.departure_timestamp >=?)) AND (t1.inventory_class IN (?, ?))) AND (t0.ID = t1.segment_id)) GROUPBY t0.service_name, t0.departure_timestamp, t0.departure_station,t0.arrival_station, t1.inventory_class, date_part(?,age(t1.create_timestamp)) bind => [6 parameters bound]Query: ReportQuery(referenceClass=Item sql="SELECT t0.service_name,t0.departure_timestamp, t0.departure_station, t0.arrival_station,t1.inventory_class, date_part(?, age(t1.create_timestamp)), COUNT(t1.ID),AVG(t1.original_price) FROM segment t0, item t1 WHERE ((((t1.product_type =?) AND (t0.departure_timestamp >= ?)) AND (t1.inventory_class IN (?, ?)))AND (t0.ID = t1.segment_id)) GROUP BY t0.service_name,t0.departure_timestamp, t0.departure_station, t0.arrival_station,t1.inventory_class, date_part(?, age(t1.create_timestamp))") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)Caused by: org.postgresql.util.PSQLException: ERROR: column"t1.create_timestamp" must appear in the GROUP BY clause or be used in anaggregate function Position: 129 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455) at $Proxy238.executeQuery(Unknown Source) at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:642) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:931) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:607) ... 2 more