org.postgresql.util.PSQLException: ERROR: IN types numeric and character varying cannot be matched      \[exec\]      \[java\] (CASE WHEN AD\_Note.AD\_Client\_ID IS NULL THEN '' ELSE  (TO\_CHAR(table1.Name) ) END) AS AD\_Client\_IDR,

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 pangeacb
, 1 year ago
ERROR: IN types numeric and character varying cannot be matched      \[exec\]      \[java\] (CASE WHEN AD\_Note.AD\_Client\_ID IS NULL THEN '' ELSE  (TO\_CHAR(table1.Name) ) END) AS AD\_Client\_IDR,
via openbravo by gotrunks
, 1 year ago
ERROR: syntax error at or near ")"      SELECT C\_Invoice.AD\_Client\_ID,      \[java\] (CASE WHEN C\_Invoice.AD\_Client\_ID IS NULL THEN '' ELSE  (TO\_CHAR(table1.Name) ) END) AS AD\_Client\_IDR,
via openbravo by nsaleh
, 1 year ago
ERROR: syntax error at or near ")" SELECT C\_Invoice.AD\_Client\_ID,  (CASE WHEN C\_Invoice.AD\_Client\_ID IS NULL THEN '' ELSE (TO\_CHAR(table1.Name) ) END) AS AD\_Client\_IDR
via openbravo by darrencarter6
, 1 year ago
ERROR: operator does not exist: numeric = character varying        AND AD\_CLIENT\_ID IN ('1')
via openbravo by theroo
, 1 year ago
ERROR: operator does not exist: numeric = character varying    '' AS process\_Params\_Code, AD\_COLUMN.AD\_PROCESS\_ID AS xmlid, mo.classname, mom.mappingname,
via openbravo by jaco_fourie
, 1 year ago
ERROR: relation "ad\_column" does not exist    ad\_column.ad\_process\_id, ad\_field.isreadonly, ad\_field.DISPLAYLOGIC, ad\_field.isEncrypted, AD\_FIELD.AD\_FIELDGROUP\_ID AS FieldGroup, ad\_field.ad\_tab\_id as tabid, '' as ad\_column\_id, '' as ad\_val\_rule\_id, '' as displaylength, '' as value, '' as ad\_window\_id,
org.postgresql.util.PSQLException: ERROR: IN types numeric and character varying cannot be matched      \[exec\]      \[java\] (CASE WHEN AD\_Note.AD\_Client\_ID IS NULL THEN '' ELSE  (TO\_CHAR(table1.Name) ) END) AS AD\_Client\_IDR,

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 day ago
Once, 1 week ago
Once, 1 week ago

Write tip

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