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

  1. ,
    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>

Solutions on the web

via Eclipse Bugzilla by drlaz, 1 year 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
, 10 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.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:891)	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:601)