Re: Updateable ResultSet

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@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com