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

JBoss Issue Tracker | Juraci Paixão Kröhling | 9 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    The following Hibernate tests fails due to "operator does not exist: bigint = character varying": NativeQueryTest#testJpaStylePositionalParametersInNativeSql FooBarTest#testCollectionsInSelect Sample stacktrace: org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2223) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152) at org.hibernate.test.jpa.ql.NativeQueryTest.testJpaStylePositionalParametersInNativeSql(NativeQueryTest.java:26) at org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:102) at org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:34) at org.hibernate.junit.functional.FunctionalTestClassTestSuite.runTest(FunctionalTestClassTestSuite.java:100) at org.hibernate.junit.functional.FunctionalTestClassTestSuite.run(FunctionalTestClassTestSuite.java:69) Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) ... 26 more

    JBoss Issue Tracker | 9 years ago | Juraci Paixão Kröhling
    org.hibernate.exception.SQLGrammarException: could not execute query
  2. 0

    Üye "Yapı Kredi"den ödemede hata

    GitHub | 3 years ago | erensenelmis
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query
  3. 0

    org.postgresql.util.PSQLException

    adempiere | 8 years ago | camiloparra
    org.postgresql.util.PSQLException: ERROR: límite de profundidad de stack alcanzado; State=54001; ErrorCode=0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    使用Spring、Hibernate、Struts的一些错误总结(不断补充) - cuiyi's blog(崔毅 crazycy) - BlogJava

    blogjava.net | 7 months ago
    org.hibernate.exception.SQLGrammarException: could not execute query
  6. 0

    How to Write an Output Connector - Apache Connectors Framework - Apache Software Foundation

    apache.org | 10 months ago
    org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database exception: Exception doing query: ERROR: unexpected chunk number 2 (expected 0) for toast value 34938 in pg_toast_2619
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. org.postgresql.util.PSQLException

    ERROR: operator does not exist: bigint = character varying

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
    6 frames
  3. Hibernate
    CustomLoader.list
    1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:187)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:674)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    5. org.hibernate.loader.Loader.doList(Loader.java:2220)
    6. org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
    7. org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    8. org.hibernate.loader.Loader.doList(Loader.java:2223)
    9. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    10. org.hibernate.loader.Loader.list(Loader.java:2099)
    11. org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
    11 frames
  4. Hibernate
    SQLQueryImpl.list
    1. org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
    2. org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
    3. org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
    3 frames
  5. org.hibernate.test
    NativeQueryTest.testJpaStylePositionalParametersInNativeSql
    1. org.hibernate.test.jpa.ql.NativeQueryTest.testJpaStylePositionalParametersInNativeSql(NativeQueryTest.java:26)
    1 frame
  6. org.hibernate.junit
    FunctionalTestClassTestSuite.run
    1. org.hibernate.junit.functional.FunctionalTestCase.runTest(FunctionalTestCase.java:102)
    2. org.hibernate.junit.UnitTestCase.runBare(UnitTestCase.java:34)
    3. org.hibernate.junit.functional.FunctionalTestClassTestSuite.runTest(FunctionalTestClassTestSuite.java:100)
    4. org.hibernate.junit.functional.FunctionalTestClassTestSuite.run(FunctionalTestClassTestSuite.java:69)
    4 frames