SEO

#1 (**permalink**) 04-16-2008, 12:59 AM

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 irun the select*statement for the row in postgresql*console it was showing*updated*value.*But today*that means after 3 days when itry*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 helpme 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

#2 (**permalink**) 04-16-2008, 12:59 AM

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Autocommit Problem