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 = ?)")

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

,
via stackoverflow.com by Unknown author

Upgrade the database driver to the latest and check.

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.3-1101-jdbc41</version>
</dependency>

Replace version with the latest driver version.

Solutions on the web

via Eclipse Bugzilla by drlaz, 10 months ago
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
via Stack Overflow by Almir Fontenele Oliveira
, 7 months ago
ERROR: current transaction is aborted, commands ignored until end of transaction block Error Code: 0 Call: Select * from Cdr_Stat where msisdn =? and callDatetime between '2016-06-03 00:00:00.00' and '2016-06-03 23:59:59.99' bind => [1 parameter
via GitHub by mheppler
, 2 years ago
ERROR: more than one row returned by a subquery used as an expression Error Code: 0 Call: select groupalias from explicitgroup where id = (select explicitgroup_id from explicitgroup_authenticateduser where containedauthenticatedusers_id = (select
via ambari-user by Darpan Patel, 1 year ago
ERROR: duplicate key value violates unique constraint "clusterservices_pkey"* * Detail: Key (service_name, cluster_id)=(KNOX, 2) already exists.* *Error Code: 0* Call: INSERT INTO clusterservices (service_name, service_enabled, cluster_id) VALUES (?, ?, ?) bind => [3 parameters bound] Query: InsertObjectQuery(org.apache.ambari.server.orm.entities.ServiceDesiredStateEntity@fadf9954 )
via ambari-user by Alejandro Fernandez, 1 year ago
ERROR: duplicate key value violates unique constraint "clusterservices_pkey" Detail: Key (service_name, cluster_id)=(KNOX, 2) already exists. Error Code: 0 Call: INSERT INTO clusterservices (service_name, service_enabled, cluster_id) VALUES (?, ?, ?) bind => [3 parameters bound] Query: InsertObjectQuery(org.apache.ambari.server.orm.entities.ServiceDesiredStateEntity@fadf9954)
via ambari-user by Alejandro Fernandez, 1 year ago
ERROR: duplicate key value violates unique constraint "clusterservices_pkey" Detail: Key (service_name, cluster_id)=(KNOX, 2) already exists. Error Code: 0 Call: INSERT INTO clusterservices (service_name, service_enabled, cluster_id) VALUES (?, ?, ?) bind => [3 parameters bound] Query: InsertObjectQuery(org.apache.ambari.server.orm.entities.ServiceDesiredStateEntity@fadf9954)
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(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.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:891)

Users with the same issue

Once, 11 hours ago
54 times, 1 week ago
Once, 4 weeks ago
Once, 1 month ago
32 times, 1 month ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.