org.hibernate.exception.SQLGrammarException: could not execute query

tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Lazy load "JOINED" collection
    via Stack Overflow by Marcelo Keiti
    ,
  • Nuclear Med data
    via by Simon Doran,
  • JBoss Community / Mailing Lists
    via by Unknown author,
  • GitHub comment 412#219778062
    via GitHub by rdp
    ,
    • org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.loader.Loader.doList(Loader.java:2536) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) at org.hibernate.loader.Loader.list(Loader.java:2271) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at com.sample.TestPerson.queryPerson(TestPerson.java:24) at com.sample.TestPerson.main(TestPerson.java:18) Caused by: org.postgresql.util.PSQLException: ERROR: column person0_.id does not exist Position: 8 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)

    Users with the same issue

    derprogger
    derprogger1 times, last one,
    Unknown User
    Unknown User7 times, last one,
    Unknown visitor1 times, last one,
    arnaudt
    arnaudt1 times, last one,
    Victor_IT
    Victor_IT18 times, last one,
    91 more bugmates