Possible Bug in PreparedStatement - Mailing list pgsql-admin

From Sabio - PSQL
Subject Possible Bug in PreparedStatement
Date
Msg-id 424DAA21.7040206@ceroriesgo.co.cr
Whole thread Raw
List pgsql-admin
Please do not respond last email, only this...

    public int cedula_actualizar(String strcedula, String strids) {
        PreparedStatement ST = null;
        int retVal = 0;
        try {
            ST = conexion.prepareStatement("UPDATE maestro_partes SET
cedula=? WHERE consecutivo_identificacion IN (?)");
             ST.setString(1, strcedula);
             ST.setString(2, strids);
            retVal = ST.executeUpdate();
            ST.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
        return retVal;
    }

When execute this function with single data like this 3434 in strids, it
works, but when is pass somethine like this: 12232,3434,3,4545,34,3
don't work, Why?
In database cedula is varchar and consecutivo_identificacion is int



pgsql-admin by date:

Previous
From: Sabio - PSQL
Date:
Subject: Help with statement
Next
From: Tom Lane
Date:
Subject: Re: Help understanding VACUUM info on 7.4.5