| From: | Indra Heckenbach <indra(at)macnica(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | selecting cursor based fetch |
| Date: | 2004-03-22 02:51:41 |
| Message-ID: | 405E54BD.8010502@macnica.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I started working with the jdbc driver on the CVS head, and found a
difference with earlier release version (driver packages with 7.4.1 I
believe). I am creating a prepared statement with
TYPE_SCROLL_INSENSITIVE and setFetchSize(20). In older version, the
JDBC driver correctly does "DECLARE CURSOR ...". On the head this is
not done. I noticed the method getQueryFragments():String[] will
transformToCursorFetch() if the statement !wantsScrollableResultSet().
Shouldn't this condition be reversed? This implementation will force
scrollable queries to be fully cached in memory. I realize this makes
methods like absolute() work properly, but these techniques prevent
cursor based positioning.
thanks,
Indra
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2004-03-22 02:55:30 | Re: absolute positioning |
| Previous Message | Indra Heckenbach | 2004-03-22 02:33:25 | absolute positioning |