Re: Updateable ResultSet

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

In response to

Browse pgsql-jdbc by date

  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