Updateable ResultSet - Mailing list pgsql-jdbc

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.kaila@iki.fi
http://www.iki.fi/kaila
tel: 050 3725844