No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish June 11, 2023 by Tarik I had this issue, and solved. This was due to the WHERE clause contains String value instead of integer value.