Updateable ResultSet

hi,

I have a Java application that inserts data (using jdbc) in the database with
methods similar to the ones below.

These methods function in MS Access 2000 and MySQL and now I am trying to
port this application to use PostgreSQL.

In PostgreSQL get the error "This resultSet is not updateable."

Any advice on how to solve this?

regards
Kaarle Kaila
-----------------

Connection con =
DriverManager.getConnection("jdbc:postgresql:kalle","kalle","");
Statement stmt = con.createStatement();
String sql = "create table koe (num int primary key,nimi
varchar(255))";
int resu = stmt.executeUpdate(sql);

sql = "insert into koe (num,nimi) values(1,'Kalle')";
resu = stmt.executeUpdate(sql);
sql = "select * from koe where num is null";
ResultSet rs = stmt.executeQuery(sql);
// above command functions OK
rs.moveToInsertRow();
rs.updateInt("num",2);
rs.updateString("nimi","Rita");
rs.insertRow();
// above commands fail in postgreSQL but are OK in other databases

stmt.close();
con.close();

--
Kaarle Kaila
mailto:kaarle(dot)kaila(at)iki(dot)fi
http://www.iki.fi/kaila
tel: 050 3725844