Re: absolute positioning - Mailing list pgsql-jdbc

From Indra Heckenbach
Subject Re: absolute positioning
Date
Msg-id 4062CA26.6060205@macnica.com
Whole thread Raw
In response to Re: absolute positioning  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Thanks for the notes on junit testing.  I neglected previous() method entirely.  I've extended that, and still working
throughsome issues.  I don't know what I'll have time for, but I would like to complete support for it.  I'll let you
knowhow things develop...<br /><br /> Indra<br /><br /> Kris Jurka wrote:<br /><blockquote
cite="midPine.BSO.4.56.0403241257030.18530@leary.csoft.net"type="cite"><pre wrap="">
 
On Wed, 24 Mar 2004, Indra Heckenbach wrote:
 </pre><blockquote type="cite"><pre wrap="">Hi Oliver,

Thanks for pointing me to this discussion.  From what I can tell, work
must have been done on the postgres backend to improve support for
cursors.  I have been using cursors with fairly complex queries (joins
and nested subqueries and order bys) without any problems. 

I went ahead and patched the JDBC jar from the CVS head on gborg.  This
patch should enable scrollable cursor support, and provide absolute() w/o
loading all results into the JDBC buffer.  Unfortunately, the patch
involves changing some core aspects of the driver.  I have not reviewed
the existing code thoroughly, so I could have introduced problems.  I
have also not tested extensively.  However, the patch works for me, and I
could use the patched driver with existing applications.  Is there a test
suite for the driver?  At this point I hope to get some feedback.
   </pre></blockquote><pre wrap="">
I'll admit I haven't actually looked at the patch, but first, patches
should be submitted in context diff format (diff -c) and there is a test
suite that can be run with "ant test", this requires setting up a test
database with a test user and making plpgsql available to it.  Right now
there are two failures from your patch.  Also this is only testing the
existing functionality, most of the tests are testing the FORWARD_ONLY
ResultSet mode, so I would hope to see some additions or modifications to
the test suite in your next patch.

Kris Jurka
 </pre></blockquote><br />

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: absolute positioning
Next
From: postgres@nitwit.de
Date:
Subject: ArrayIndexOutOfBoundsException - bug?