org.postgresql.util.PSQLException: ERROR: IN types numeric and character varying cannot be matched

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>

Solutions on the web

via openbravo by carlossl
, 1 year ago
ERROR: IN types numeric and character varying cannot be matched
via openbravo by jesuscampos19
, 1 year ago
ERROR: IN types numeric and character varying cannot be matched
via openbravo by jesuscampos19
, 1 year ago
ERROR: IN types numeric and character varying cannot be matched
via openbravo by gammag
, 1 year ago
ERROR: column "rownum" does not exist
via openbravo by davidcantero
, 1 year ago
ERROR: control reached end of function without RETURN
via openbravo by steve_yxf
, 1 year ago
ERROR: control reached end of function without RETURN
org.postgresql.util.PSQLException: ERROR: IN types numeric and character varying cannot be matched
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at org.openbravo.data.Sqlc.query(Unknown Source)
at org.openbravo.data.Sqlc.endElement(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source)
at org.openbravo.data.Sqlc.listDir(Unknown Source)
at org.openbravo.data.Sqlc.listDir(Unknown Source)
at org.openbravo.data.Sqlc.listDir(Unknown Source)
at org.openbravo.data.Sqlc.listDir(Unknown Source)
at org.openbravo.data.Sqlc.listDir(Unknown Source)
at org.openbravo.data.Sqlc.main(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 times, 1 year ago
104 more bugmates

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