i am developing an application using tomcat 5.5.6 and postgrsql7.3 (pg73jdbc3.jar) deployed inRedHat linux. Three days earlier updated acolumn of particular row in a table . When i retrieved thesame row from the JSP page it was showing OK.Even when i run theselect statement for the row in postgresql console it wasshowing updated value. But today that means after 3 days when i try to view the row it is showing the old valueforthe row. When i run the select statement for the row inposgresql console it is showing the old value. How can it happen?Can you please help me out. My java code for the updation isshown below.....
String sql = "UPDATE ........"; Connection con =DBConnection.getConnection(); // DBConnectio is aclass for getting 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(); }