| From: | Joseph Shraibman <jks(at)selectacast(dot)net> | 
|---|---|
| To: | "Mike D'Agosta" <mdagosta(at)tolosatech(dot)com> | 
| Cc: | pgsql-jdbc(at)postgresql(dot)org | 
| Subject: | Re: Updateable ResultSet | 
| Date: | 2001-05-07 20:43:29 | 
| Message-ID: | 3AF708F1.899D1675@selectacast.net | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-jdbc | 
Mike D'Agosta wrote:
> 
> Hello,
> 
>     I am brand new to this list. I looked through the mailing list archive,
> but couldn't determine if ResultSets are Updateable yet. I'm using some old
> drivers for pgsql-jdbc. Are there drivers out now that have Updateable
> ResultSets?
> 
ResultSets can't be updatable because that would require the ResultSet
to lock the backend in a begin/end block, which means that if you used
the Connection to do something else while you had the ResultSet open you
might mess it up.  And since using a seperate new Connection would mean
forking off a new backed it is unreasonable to create a new connection
every time you need a ResultSet.
-- 
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio.  http://www.targabot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2001-05-07 22:43:19 | 'current' timestamp chokes jdbc driver | 
| Previous Message | Tim Barnard | 2001-05-07 19:16:30 | A different compile problem for 7.1.1 |