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


Samebug tips1

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>


7 months ago
Expert tip

Solutions on the web80

Solution icon of bugzilla
via Eclipse Bugzilla by drlaz, 8 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

Solution icon of stackoverflow
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

Solution icon of stackoverflow
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

Solution icon of stackoverflow
FEHLER: Operator existiert nicht: name = integer Hinweis: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. Position: 57 Error Code: 0 Call: SELECT

Solution icon of stackoverflow
ERROR: relation "dashboardwidget" does not exist Position: 18 Error Code: 0 Call: SELECT TYPE FROM DASHBOARDWIDGET WHERE (COMPANY_ID = ?) bind => [8888810010000000000] Query: ReportQuery(referenceClass=DashboardWidget sql="SELECT TYPE FROM DASHBOARDWIDGET WHERE (COMPANY_ID = ?)")

Solution icon of stackoverflow
", "PKHASHCODE", "SCHEDULE", "STATE" FROM "EJB__TIMER__TBL" WHERE (("OWNERID" = ?) AND ("STATE" = ?)) bind =&gt; [2 parameters bound] Query: ReadAllQuery(name="findTimersByOwnerAndState" referenceClass=TimerState sql="SELECT "TIMERID", "APPLICATIONID

Solution icon of stackoverflow
ERROR: relation "utilisateur" does not exist Position: 154 Error Code: 0 Call: SELECT Mail_Utilisateur, Adresse_Utilisateur, Mdp_Utilisateur, Nom_Utilisateur, Prenom_Utilisateur, Profile_Utilisateur, Tel_Utilisateur, Nom_Ville FROM UTILISATEUR WHERE

Solution icon of github
via GitHub by mheppler
, 1 year ago
ERROR: column "frenchdescription" does not exist Position: 161 Error Code: 0 Call: SELECT ID, ADVANCEDSEARCHFIELDTYPE, ALLOWCONTROLLEDVOCABULARY, ALLOWMULTIPLES, description, DISPLAYFORMAT, DISPLAYONCREATE, DISPLAYORDER, FACETABLE, FIELDTYPE

Solution icon of stackoverflow
ERROR: no existe la columna «idcompany» Hint: Perhaps you meant to reference the column "company_subscripcion.id_company". Position: 16 Error Code: 0 Call: SELECT STATUS, IDCOMPANY, IDSUSCRIPTION, COMPANY_id_company, SUBSCRIPTION_id_suscription

Solution icon of web
ERROR: relation "application" does not exist Position: 16 Error Code: 0 Call: SELECT ? FROM application LIMIT ? OFFSET ? bind => [3 parameters bound] Query: ReportQuery(referenceClass=Application sql="SELECT ? FROM application LIMIT ? OFFSET ?")

Stack trace

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 = ?)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1415)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:678)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:529)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:914)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:618)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2537)
	at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2496)
	at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:455)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:997)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:675)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:958)
	at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:432)
	at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2322)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
	at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1019)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2863)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
	at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiate(QueryBasedValueHolder.java:85)
	at org.eclipse.persistence.internal.indirection.QueryBasedValueHolder.instantiateForUnitOfWorkValueHolder(QueryBasedValueHolder.java:100)
	at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiateImpl(UnitOfWorkValueHolder.java:156)
	at org.eclipse.persistence.internal.indirection.UnitOfWorkValueHolder.instantiate(UnitOfWorkValueHolder.java:230)
	at org.eclipse.persistence.internal.indirection.DatabaseValueHolder.getValue(DatabaseValueHolder.java:83)
	at org.eclipse.persistence.indirection.IndirectMap.buildDelegate(IndirectMap.java:110)
	at org.eclipse.persistence.indirection.IndirectMap.getDelegate(IndirectMap.java:316)
	at org.eclipse.persistence.indirection.IndirectMap$1.<init>(IndirectMap.java:187)
	at org.eclipse.persistence.indirection.IndirectMap.entrySet(IndirectMap.java:186)
	at org.eclipse.persistence.internal.queries.MapContainerPolicy$MapContainerPolicyIterator.<init>(MapContainerPolicy.java:811)
	at org.eclipse.persistence.internal.queries.MapContainerPolicy.iteratorFor(MapContainerPolicy.java:453)
	at org.eclipse.persistence.mappings.AggregateCollectionMapping.cascadePerformRemoveIfRequired(AggregateCollectionMapping.java:379)
	at org.eclipse.persistence.internal.descriptors.ObjectBuilder.cascadePerformRemove(ObjectBuilder.java:1485)
	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.performRemove(UnitOfWorkImpl.java:3561)
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.remove(EntityManagerImpl.java:435)
	at org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationJUnitTestSuite.testManyToManyMapping(DDLGenerationJUnitTestSuite.java:767)
	at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:428)
	at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248)
	at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:208)
	at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313)
Caused by: 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)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
16 times, 2 months ago
Once, 4 months ago
Samebug visitor profile picture
Unknown user
2 times, 8 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
101 more bugmates