Ultimately it came down to what to use in the statement "IN" or "ANY". I've Changed to "ANY" and it works as expected

PreparedStatement myStatement =  connection.prepareStatement(
                """
                        SELECT path
                        FROM   my_table
                        WHERE  path = ANY ( ? )
                        """);