Re: how to resolve org.postgresql.util.PSQLException: ERROR: operatordoes not exist: text = integer?

Your query only has one comparison operation, ANY. In order for the query to get as far as it did it must have two question marks present in the ANY expression (since you've set two parameters in Java).  Since the left side of the ANY equality is subject_name you are attempting to compare against the text type.

So explain why you think sticking an integer into the first parameter location is something that makes sense here; i.e., ps2.setInt(1, tutor_id); because that, with the information you've provided, is your error.

David J.