From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | Kovács Péter <peter(dot)kovacs(at)sysdata(dot)siemens(dot)hu> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: JDBC 2 ResultSet and cursors |
Date: | 2001-10-16 21:54:22 |
Message-ID: | 3BCCAC8E.6050109@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Because the driver would have to dedicate a connection to the backend to the resultset to
make sure nobody else tries to begin/end a block while it is trying to use a cursor.
(that's the simple explanation) Since a connection to the backend currently requires a
fork, it would be a real resource hog.
Kovács Péter wrote:
> Hi,
>
> I have a question for which I can think of an answer, but still I am
> uncertain about it.
>
> Why the scrollable result sets are not implemented in the current jdbc
> driver? Is it technically impossible or just no one needed this feature yet?
>
> The answer is probably that due to the lack of backend support for updatable
> cursors the scrollable result set would not be fully functional. (On the
> face of it, I think that it should be possible to build support for
> read-only scrollable result set into the jdbc driver.) But would a halfway
> solution not be better than nothing? You need to resort to workarounds
> anyway, if you want to use cursor based data processing with PostgreSQL.
> IMHO, a read-only scrollable result set would definitly be an important step
> toward code portability.
>
> Any comments?
>
> Does anyone have info on whether there are plans to implement support for
> updatable cursors in the backend? If there are, what are they?
>
> Thank you
>
> Peter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
--
Joseph Shraibman
jks(at)selectacast(dot)net
Increase signal to noise ratio. http://www.targabot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-10-17 01:11:36 | Re: J2SE 1.4 and other patches |
Previous Message | Joseph Shraibman | 2001-10-16 21:49:59 | Re: J2SE 1.4 and other patches |