JDBC 2 ResultSet and cursors

From: Kovács Péter <peter(dot)kovacs(at)sysdata(dot)siemens(dot)hu>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC 2 ResultSet and cursors
Date: 2001-10-16 07:20:20
Message-ID: 8A2DDD7ED7876A4698F6FF204F62CBFC014E5156@budg112a.sysdata.siemens.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kovács Péter 2001-10-16 09:48:35 Re: jdbc capabilities
Previous Message Dave Cramer 2001-10-15 23:49:12 Re: Question of JDBC Driver