org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 72 Error Code: 0 Call: SELECT DESCRIPTION, aCMap_KEY FROM MapHolder_ACMAP WHERE (MapHolder_ID = ?) bind => [5] Query: ReadAllQuery(name="aCMap" referenceClass=AggregateMapValue sql="SELECT DESCRIPTION, aCMap_KEY FROM MapHolder_ACMAP WHERE (MapHolder_ID = ?)")

Eclipse Bugzilla | drlaz | 8 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Error in SPRING JPA using eclipse link POSTGRESQL when executing findBy[NAME]In(List ids)

    Stack Overflow | 3 years ago | user3110615
    org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = record Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 160 Error Code: 0 Call: SELECT ID, amount, comment, created_date, currency, status, transaction_step, transaction_type, version, provider_id, user_id FROM anix.transactions WHERE (ID IN ((?,?))) bind => [2, 3] Query: ReadAllQuery(referenceClass=Transaction sql="SELECT ID, amount, comment, created_date, currency, status, transaction_step, transaction_type, version, provider_id, user_id FROM anix.transactions WHERE (ID IN (?))")
  2. 0

    No operator matches the given name and argument type(s). You might need to add explicit type casts. -- Netbeans, Postgresql 8.4 and Glassfish

    Stack Overflow | 6 years ago | Sam
    org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 38 Error Code: 0
  3. 0

    PostgreSQL and Glassfish EJB__TIMER__TBL table

    Stack Overflow | 4 years ago | Olivier J.
    org.postgresql.util.PSQLException: ERREUR: la relation « EJB__TIMER__TBL » n'existe pas Position : 193 Error Code: 0 Call: SELECT "TIMERID", "APPLICATIONID", "BLOB", "CONTAINERID", "CREATIONTIMERAW", "INITIALEXPIRATIONRAW", "INTERVALDURATION", "LASTEXPIRATIONRAW", "OWNERID", "PKHASHCODE", "SCHEDULE", "STATE" FROM "EJB__TIMER__TBL" WHERE (("OWNERID" = ?) AND ("STATE" = ?)) bind => [2 parameters bound] Query: ReadAllQuery(name="findTimersByOwnerAndState" referenceClass=TimerState sql="SELECT "TIMERID", "APPLICATIONID", "BLOB", "CONTAINERID", "CREATIONTIMERAW", "INITIALEXPIRATIONRAW", "INTERVALDURATION", "LASTEXPIRATIONRAW", "OWNERID", "PKHASHCODE", "SCHEDULE", "STATE" FROM "EJB__TIMER__TBL" WHERE (("OWNERID" = ?) AND ("STATE" = ?))")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Unable to bind Integer null to a parameter in Query

    Eclipse Bugzilla | 8 years ago | drlaz
    org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 72 Error Code: 0 Call: SELECT DESCRIPTION, aCMap_KEY FROM MapHolder_ACMAP WHERE (MapHolder_ID = ?) bind => [5] Query: ReadAllQuery(name="aCMap" referenceClass=AggregateMapValue sql="SELECT DESCRIPTION, aCMap_KEY FROM MapHolder_ACMAP WHERE (MapHolder_ID = ?)")
  6. 0

    GitHub comment 3327#250210439

    GitHub | 5 months ago | mheppler
    org.postgresql.util.PSQLException: ERROR: column "frenchdescription" does not exist Position: 161 Error Code: 0 Call: SELECT ID, ADVANCEDSEARCHFIELDTYPE, ALLOWCONTROLLEDVOCABULARY, ALLOWMULTIPLES, description, DISPLAYFORMAT, DISPLAYONCREATE, DISPLAYORDER, FACETABLE, FIELDTYPE, frenchdescription, frenchtitle, name, REQUIRED, title, WATERMARK, METADATABLOCK_ID, PARENTDATASETFIELDTYPE_ID FROM DATASETFIELDTYPE ORDER BY ID Query: ReadAllQuery(referenceClass=DatasetFieldType sql="SELECT ID, ADVANCEDSEARCHFIELDTYPE, ALLOWCONTROLLEDVOCABULARY, ALLOWMULTIPLES, description, DISPLAYFORMAT, DISPLAYONCREATE, DISPLAYORDER, FACETABLE, FIELDTYPE, frenchdescription, frenchtitle, name, REQUIRED, title, WATERMARK, METADATABLOCK_ID, PARENTDATASETFIELDTYPE_ID FROM DATASETFIELDTYPE ORDER BY ID")

  1. csanyigabor 4 times, last 6 months ago
  2. Tahir 1 times, last 6 months ago
  3. RoiOtero 3 times, last 7 months ago
  4. haerick 8 times, last 8 months ago
  5. silex 15 times, last 9 months ago
2 more registered users
34 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. org.postgresql.util.PSQLException

    ERROR: operator does not exist: character varying = integer Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 72

    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. EclipseLink (non-OSGi)
    DatabaseAccessor.basicExecuteCall
    1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:891)
    2. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:601)
    2 frames