No errors but no update on table

[Rob Lynn]

I have the following code:

 
  conn = ds.getConnection(); 
  
  //Will want to use this to turn off autocommit
  //and then save all-or-nothing
  conn.setAutoCommit( false );
        
  stmt = conn.prepareStatement("update user set username = ?, " +
"firstname = ?, " +
"middleinitial = ?, " +
"lastname = ?, " +
"address1 = ?, " +
"address2 = ?, " +
"city = ?, " +
"state = ?, " +
"zip = ?, " +
"phone = ?, " +
"dsn = ?, " +
"passcode = ?, " +
"email = ? " +
"where id = ?");
  
  stmt.setString(1, user.getUsername());
  stmt.setString(2, user.getFirstName());
  stmt.setString(3, user.getMiddleInit());
  stmt.setString(4, user.getLastName());
  stmt.setString(5, user.getAddress1());
  stmt.setString(6, user.getAddress2());
  stmt.setString(7, user.getCity());
  stmt.setString(8, user.getState());
  stmt.setString(9, user.getZip());
  stmt.setString(10, user.getPhone());
  stmt.setString(11, ""); //TODO: no dsn yet on screen
  stmt.setString(12, user.getPasscode());
  stmt.setString(13, user.getEmail());
  stmt.setInt(14, user.getId());
  
  try 
{
  result=stmt.executeUpdate();
    
  //if update fails,rollback and discontinue
  if(result==0)
  {
      conn.rollback();
//throw new DataException("User update failed");
    logger.error("User update failed");
  }
} catch (SQLException se) 
    {
      conn.rollback();
    //throw new DataException("There was an update error", se);
      logger.error("exception:  " + se.getMessage());
    } catch (Exception e) 
    {
    conn.rollback();
    //throw new DataException("Some error occurred...", e);
    logger.error("exception:  " + e.getMessage());
    }
          // Commit to the database
  conn.commit();
  } catch (SQLException e) 
  {
//throw new DataException("Some SQL error occurred", e);
  logger.error("exception:  " + e.getMessage());
  } catch (NamingException e) 
  {
//throw new DataException("Some naming error occurred", e);
  logger.error("exception:  " + e.getMessage());
} finally 
{
        // Always make sure result sets and statements are closed,
        // and the connection is returned to the pool
    closeConnections(rs, stmt, conn);
        }

When I step through the code it seems to be fine - no exceptions thrown, etc. However, the change does not appear in the database. I have the correct database name in server.xml. Why would this be failing? BTW, I am trying this because when I tried Spring's jdbc, the table would be corrupted each time, and I had to delete the table and start over.
[ August 18, 2005: Message edited by: Bear Bibeault ]

[Jeanne Boyarsky]

Rob,
Can you insert a println or check in the debugger that the commit is getting executed?

[Roger Chung-Wee]

Are you certain that the row to be updated exists in the DB?

Also, I'd prefer to do this, it's much more obvious what you are trying to do:

if(result==0)
{
    conn.rollback();
//throw new DataException("User update failed");
    logger.error("User update failed");
}
else
{
    conn.commit();
}