The following bug has been logged online:

Bug reference: 2680
Logged by: Ravindra
Email address: ravi (AT) computer (DOT) org
PostgreSQL version: 8.1.4
Operating system: Debian
Description: Update statement did not work with String object
Details:

when i create a string object with the SQL statement and feed to
statement.executeUpdate(),nothing happens.
but if i write the sql with in statement.executeUpdate() it works.

Following code does not work
String sql="update FieldOptions set option_description='"+newValue+"'
where field_name='country' and
option_code='"+(this.countryCode.trim())+"'";
Connection cn=context.getDBConnection();
statement=cn.createStatement();
int res=statement.executeUpdate(sql);
cn.commit();

but instead of the "sql" String object if i feed the string directly it
works. as given below

int res=statement.executeUpdate("update FieldOptions set
option_description='"+newValue+"' where field_name='country' and
option_code='"+(this.countryCode.trim())+"'");


pleaese check

thanks

ravindra

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq