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: | Raw Message | Whole Thread | 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 |