Cursors and JDBC

Started by Wiebe de Jongover 21 years ago2 messagesgeneral
Jump to latest
#1Wiebe de Jong
wiebedj@shaw.ca

I am trying to implement cursors using JDBC connector version 7.1b5
(postgresql-7.1b5.jar), but can't get it to work.

Could anybody suggest the proper way to do it, or even some source code? I
am stuck with this version and can't change it.

Thanks

Wiebe de Jong

#2Kris Jurka
books@ejurka.com
In reply to: Wiebe de Jong (#1)
Re: Cursors and JDBC

On Mon, 4 Oct 2004, Wiebe de Jong wrote:

I am trying to implement cursors using JDBC connector version 7.1b5
(postgresql-7.1b5.jar), but can't get it to work.

Before saying anything else, I have to tell you to get off 7.1, especially
a beta version of it.

The first JDBC driver to have cursor support was the 7.4 series. It has
been tested for backward compatibility to 7.2, but not 7.1. That said I
believe it should work against a 7.1 server. So download a 7.4 jar file
from http://jdbc.postgresql.org/download.html and see this documentation:

http://www.postgresql.org/docs/7.4/static/jdbc-query.html#JDBC-QUERY-WITH-CURSOR

Kris Jurka