Re: Updateable ResultSet

Only the dev driver supports updateable result sets

Dave
On Sat, 2002-08-17 at 13:07, Kaarle Kaila wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>