Re: Autocommit Problem

Mridu,

this row doesn't make sense:

if (rowsUpdated != 1) {

I'm sure this should be

if (rowsUpdated == 1) {

Kind regards

Markus

mp.rajkhowa schrieb:
> hello
>
> i am developing an application using tomcat 5.5.6 and postgrsql7.3
> (pg73jdbc3.jar) deployed in RedHat linux. Three days earlier updated
> a column of particular row in a table . When i retrieved the same row
> from the JSP page it was showing OK.Even when i run the select statement
> for the row in postgresql console it was showing updated value. But
> today that means after 3 days when i try to view the row it is showing
> the old value of row. When i run the select statement for the row in
> postgresql console it is showing the old value. How can it happen?Can
> you please help me out. My java code for the updation is shown below.....
>
> String sql = "UPDATE ........";
> Connectioncon =DBConnection.getConnection(); // DBConnectio is
> aclass forgetting theconnection
> Statement stmt = con.createStatement();
> // Update a row
> try {
> con.setAutoCommit(false);
> int rowsUpdated = stmt.executeUpdate(sql);
> if (rowsUpdated != 1) {
> System.out.println("Success");
> }
> con.commit();
> }
> finally {
> stmt.close();
> }
>
>
> with regards
> Mridu Pobon Rajkhowa