org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

postgresql.org | 2 months ago
tip
Do you find the tips below useful? Click on the to mark them and say thanks to rafael . Or join the community to write better ones.
  1. 0
    samebug 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>
  2. 0

    Error with rewrite convert to PostgreSQL

    adempiere | 1 decade ago | vpj-cd
    org.postgresql.util.PSQLException: ERROR: syntax error at end of input; State=42601; ErrorCode=0
  3. 0

    Glassfish 4 - JdbcRealm - PostgreSql Problem

    Oracle Community | 3 years ago | asilter
    org.postgresql.util.PSQLException: ERROR: relation "users" does not exist Position: 22
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error Create new Client

    adempiere | 1 decade ago | vpj-cd
    org.postgresql.util.PSQLException: ERROR: OLD used in query that is not in a rule; State=42601; ErrorCode=0
  6. 0

    problem on install on windows server 2003

    openbravo | 9 years ago | johandepauw
    org.postgresql.util.PSQLException: ERROR: operator does not exist: numeric = character varying
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

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)
    6 frames
  3. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor421.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    3. java.lang.reflect.Method.invoke(Method.java:599)
    3 frames
  4. PostgreSQL JDBC Driver
    AbstractJdbc23PooledConnection$StatementHandler.invoke
    1. org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:471)
    1 frame
  5. Unknown
    $Proxy45.executeQuery
    1. $Proxy45.executeQuery(Unknown Source)
    1 frame
  6. Jencks
    PreparedStatementHandle.executeQuery
    1. org.tranql.connector.jdbc.PreparedStatementHandle.executeQuery(PreparedStatementHandle.java:49)
    1 frame
  7. OpenJPA Aggregate Jar
    QueryImpl.getResultList
    1. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:264)
    2. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:842)
    3. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
    4. org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedStatement.executeQuery(PostgresDictionary.java:365)
    5. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
    6. org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1372)
    7. org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
    8. org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:372)
    9. org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:330)
    10. org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:407)
    11. org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:218)
    12. org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:208)
    13. org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
    14. org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
    15. org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1223)
    16. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
    17. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842)
    18. org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:773)
    19. org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525)
    20. org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:237)
    21. org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:277)
    21 frames
  8. com.tnhsp.sbean
    WasteDetailsSBean.findForModifyWard
    1. com.tnhsp.sbean.biomedicalwaste.WasteDetailsSBean.findForModifyWard(WasteDetailsSBean.java:155)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    4. java.lang.reflect.Method.invoke(Method.java:599)
    4 frames
  10. OpenEJB :: OSGi :: Core
    Jdk13InvocationHandler.invoke
    1. org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
    2. org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
    3. org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:67)
    4. org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:210)
    5. org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:188)
    6. org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:165)
    7. org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:217)
    8. org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:77)
    9. org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:245)
    10. org.apache.openejb.util.proxy.Jdk13InvocationHandler.invoke(Jdk13InvocationHandler.java:49)
    10 frames
  11. Unknown
    $Proxy21.findForModifyWard
    1. $Proxy21.findForModifyWard(Unknown Source)
    1 frame
  12. com.tnhsp.mbeans
    wasteDetailsMBean.actionGo
    1. com.tnhsp.mbeans.biomedicalwaste.wasteDetailsMBean.actionGo(wasteDetailsMBean.java:242)
    1 frame
  13. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    4. java.lang.reflect.Method.invoke(Method.java:599)
    4 frames
  14. Pax Jsp
    JspMethodExpression.invoke
    1. org.apache.el.parser.AstValue.invoke(AstValue.java:172)
    2. org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
    3. org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)
    3 frames
  15. JavaEE 7
    _MethodExpressionToMethodBinding.invoke
    1. javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:75)
    1 frame
  16. Impl
    ActionListenerImpl.processAction
    1. org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:54)
    1 frame
  17. JavaEE 7
    UICommand.broadcast
    1. javax.faces.component.UICommand.broadcast(UICommand.java:121)
    1 frame
  18. RichFaces Core API
    AjaxViewRoot.processApplication
    1. org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321)
    2. org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296)
    3. org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253)
    4. org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466)
    4 frames
  19. Impl
    LifecycleImpl.execute
    1. org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
    2. org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103)
    3. org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76)
    3 frames
  20. JavaEE 7
    FacesServlet.service
    1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:148)
    1 frame
  21. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  22. Unknown
    SessionFilter.doFilter
    1. SessionFilter.doFilter(SessionFilter.java:43)
    1 frame
  23. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  24. org.ajax4jsf.webapp
    BaseFilter.doFilter
    1. org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
    2. org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
    3. org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368)
    4. org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495)
    4 frames
  25. Glassfish Core
    StandardContextValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    4 frames
  26. org.apache.geronimo
    GeronimoBeforeAfterValve.invoke
    1. org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
    2. org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:406)
    3. org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:47)
    3 frames
  27. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    4. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568)
    5. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    5 frames
  28. Grizzly HTTP
    JIoEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    3. org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    3 frames
  29. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:735)
    1 frame