Hosting Provided By

Re: [JDBC] Autocommit Problem

From: Markus Riehl <mriehl(at)skat.com>
Date: Fri Jan 11 2008 - 00:36:50 EST

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

Received on Fri Jan 11 00:39:02 2008

Do you need help?

This message: [ Message body ]
Next message: Achilleas Mantzios: "Re: [JDBC] Timestamps without time zone"
Previous message: Kris Jurka: "Re: [JDBC] Deleting LargeObjects as BLOBS"
In reply to: mp.rajkhowa: "[JDBC] Autocommit Problem"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:42:36 EDT