javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement

GitHub | mdomasevicius | 3 months ago
  1. 0

    Subquery alias does not work in querydsl 4

    GitHub | 3 months ago | mdomasevicius
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
  2. 0

    PSQLException: ERROR: syntax error at or near "TableName" Position: 1

    Stack Overflow | 6 months ago | praveen
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    When using the SQL function {{values}} with a single value list, a JPA query such as {{'from Employee e where id in (values(?1), (?2))'}} fails when run against PostgreSQL: {panel} javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:492) ... Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79) at org.hibernate.loader.Loader.getResultSet(Loader.java:2115) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1874) at org.hibernate.loader.Loader.doQuery(Loader.java:919) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336) at org.hibernate.loader.Loader.doList(Loader.java:2610) at org.hibernate.loader.Loader.doList(Loader.java:2593) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422) at org.hibernate.loader.Loader.list(Loader.java:2417) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371) at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339) at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87) at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606) at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:483) ... Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$2" Position: 181 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70) ... {panel} Interestingly, a similar query structure works (because the second pair is seen as a vector rather than anything related to the values function): {{... values(?1,?2), (?3,?4) ...}} Since the query includes an SQL function which is outside of what is supported by the JPA specification, should the Hibernate parser raise an exception for the use of values?

    Hibernate JIRA | 6 months ago | Stephen Fikes
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet

  1. Tahir 2 times, last 3 months ago
  2. thiago.santos 2 times, last 6 months ago
  3. mauritius 6 times, last 9 months ago
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. javax.persistence.PersistenceException

    org.hibernate.exception.SQLGrammarException: could not prepare statement

    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert()
  2. org.hibernate.jpa
    QueryImpl.getResultList
    1. org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
    2. org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
    3. org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:492)
    3 frames
  3. com.querydsl.jpa
    AbstractJPAQuery.fetch
    1. com.querydsl.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:160)
    2. com.querydsl.jpa.impl.AbstractJPAQuery.fetch(AbstractJPAQuery.java:202)
    2 frames