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

Re: deleteRow or updateRow after insertRow

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: jessica xingzc_he <xingzc_he(at)hotmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: deleteRow or updateRow after insertRow
Date: 2004-11-18 23:26:44
Message-ID: 419D2FB4.2030407@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
You may need to tell us a little more like what version of the driver 
you are using ?

--dc--

jessica xingzc_he wrote:

> does anyone know why this happen?
>
> I do first:
> ResultSet.moveToInsertRow();
> ResultSet.update...(1, ...);
> ....
> rs.insertRow(); // a new row inserted into table
>
> but after that, I may move to some other row, say using 
> Result.absolute(..) or so, and then
> 1. update
> ResultSet.update...(1, ...);
> ...
> ResultSet.updateRow(); // it does not update the corresponding row in 
> the table, but also no
>                                     exception thrown.
>
> 2. delete
> ResultSet.deleteRow(); // throws exception: Can not call deleteRow() 
> when on insert row.
>
> anybody has any clue? thanks
>
> zhenchang
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>      message can get through to the mailing list cleanly
>
>

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


In response to

Responses

pgsql-jdbc by date

Next:From: Ian PilcherDate: 2004-11-18 23:42:53
Subject: Re: Why IDENT doesn't work with JDBC
Previous:From: Oliver JowettDate: 2004-11-18 23:23:14
Subject: Re: Why IDENT doesn't work with JDBC

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