Skip site navigation (1) Skip section navigation (2)

Re: Updateable ResultSet

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: kaarle(dot)kaila(at)iki(dot)fi
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Updateable ResultSet
Date: 2002-08-17 17:16:09
Message-ID: 1029604570.1947.162.camel@inspiron.cramers (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(dot)kaila(at)iki(dot)fi
> http://www.iki.fi/kaila
> tel: 050 3725844
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> 




In response to

Responses

pgsql-jdbc by date

Next:From: Kaarle KailaDate: 2002-08-17 17:52:02
Subject: Re: Updateable ResultSet
Previous:From: Kaarle KailaDate: 2002-08-17 17:07:48
Subject: Updateable ResultSet

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group