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

JBoss Issue Tracker | Juraci Paixão Kröhling | 8 years ago
  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 | 8 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

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

    blogjava.net | 2 months ago
    org.hibernate.exception.SQLGrammarException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

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

    apache.org | 6 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
  6. 0

    GitHub comment 12#75881875

    GitHub | 2 years ago | rmfalcao
    org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying >= date
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