JDBC Newbie Question

I am doing some first tinkering with JDBC and PostgreSQL and I am stumped on
something.

I have a simple Java program that queries a table on the PostgreSQL
workstation successfully.  I can iterate through the rows and display them.
However, when I try to update a value, like using:   ResultSet rs;   ...   rs.updateInt("columnName", newIntVal);

The rs.updateInt() seems to succeed (no exceptions thrown), but the database
never gets changed.  I am using JBuilder 4, and I *can* make changes to the
DB using the Data Explorer tool.  So, the jdbc driver appears to be working.

FYI, my connection logic starts as follows:   ...   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  // load database
interface   conn = DriverManager.getConnection("jdbc:odbc:postgresql", "myusername",
"mypassword");   stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATA
BLE);   res = stmt.executeQuery("SELECT * FROM customer FOR UPDATE");   ...

Any ideas?

--
John McLaughlin
_______________________
johnm@oei.com