Possible Bug in PreparedStatement

From: Sabio - PSQL <slopez_pg(at)ceroriesgo(dot)co(dot)cr>
To: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Possible Bug in PreparedStatement
Date: 2005-04-01 20:08:01
Message-ID: 424DAA21.7040206@ceroriesgo.co.cr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-04-01 21:06:38 Re: Help understanding VACUUM info on 7.4.5
Previous Message Sabio - PSQL 2005-04-01 20:04:41 Help with statement