org.postgresql.util.PSQLException: ERROR: operator does not exist: date = bytea Wskazówka: No operator matches the given name and argument type(s). You might need to add explicit type casts. Pozycja: 119

Hibernate JIRA | Radosław Smogura | 6 years ago
  1. 0

    An Entity that has Date field, is then searched against value from this field, this causes to throw PSQL error :Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: date = bytea Wskazówka: No operator matches the given name and argument type(s). You might need to add explicit type casts. Pozycja: 119 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source) 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 $Proxy243.executeQuery(Unknown Source) at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:641) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2533) Error is probably caused, because the return type of Date filed is java.sql.Date or java.sql.Timestamp (this last works). I will attach sample application.

    Hibernate JIRA | 6 years ago | Radosław Smogura
    org.postgresql.util.PSQLException: ERROR: operator does not exist: date = bytea Wskazówka: No operator matches the given name and argument type(s). You might need to add explicit type casts. Pozycja: 119
  2. 0

    An Entity that has Date field, is then searched against value from this field, this causes to throw PSQL error :Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: date = bytea Wskazówka: No operator matches the given name and argument type(s). You might need to add explicit type casts. Pozycja: 119 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source) 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 $Proxy243.executeQuery(Unknown Source) at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:641) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) at org.hibernate.loader.Loader.doQuery(Loader.java:802) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) at org.hibernate.loader.Loader.doList(Loader.java:2533) Error is probably caused, because the return type of Date filed is java.sql.Date or java.sql.Timestamp (this last works). I will attach sample application.

    Hibernate JIRA | 6 years ago | Radosław Smogura
    org.postgresql.util.PSQLException: ERROR: operator does not exist: date = bytea Wskazówka: No operator matches the given name and argument type(s). You might need to add explicit type casts. Pozycja: 119
  3. 0

    Problem of case with "PUBLIC" schema in PostGIS

    GitHub | 3 years ago | gpetit
    org.postgresql.util.PSQLException: ERREUR: la relation « PUBLIC.test » n'existe pas Position : 15
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Bug when you change default schema with PostgreSQL

    GitHub | 3 years ago | mlecoeuvre
    org.postgresql.util.PSQLException: ERREUR: la relation « geometry_columns » n'existe pas Position : 15
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: date = bytea Wskazówka: No operator matches the given name and argument type(s). You might need to add explicit type casts. Pozycja: 119

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    6 frames
  3. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor256.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  4. PostgreSQL JDBC Driver
    AbstractJdbc23PooledConnection$StatementHandler.invoke
    1. org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    1 frame
  5. Unknown
    $Proxy243.executeQuery
    1. $Proxy243.executeQuery(Unknown Source)
    1 frame
  6. Embedded GlassFish Web
    PreparedStatementWrapper40.executeQuery
    1. com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:641)
    1 frame
  7. Hibernate
    Loader.doList
    1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:802)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    5. org.hibernate.loader.Loader.doList(Loader.java:2533)
    5 frames