473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Cursors and JDBC

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


Nov 23 '05 #1
1 1747


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/s...RY-WITH-CURSOR

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Alban Hertroys | last post by:
Oh no! It's me and transactions again :) I'm not really sure whether this is a limitation of psycopg or postgresql. When I use multiple cursors in a transaction, the records inserted at the...
0
by: Rahul Sachan | last post by:
Dear All, We are using Oracle 9i databse and Oracle JDBC Driver version - 9.0.2.0.0(oracle.jdbc.driver.OracleDriver) with JDBC 2.0. 1) The following block of statement returns 0 when executed....
3
by: Deepali Gupta | last post by:
We are encountering the problem of "maximum open cursors exceeded" exception. Our web based system uses jdk1.3 as frontend with Oracle 9i as backend and Oracle JDBC Driver version - 9.0.2.0.0...
0
by: David | last post by:
Does anybody have samples of how to use JDBC calls to work with a cursor on Oracle 8i? Can it even be done? I'd like to be able to do something like: String sql = "DECLARE CURSOR my_cursor...
6
by: a | last post by:
Hello, I am doing some multithreading in an MDI app, and I can't seem to get the cursor to stay as an Hourglass. I call: Cursor.Current = cursors.wait at the beginning of my routing, and...
10
by: Just Me | last post by:
Does Me.Cursor.Current=Cursors.WaitCursor set the current property of Me.Cursor to Cursors.WaitCursor And Me.Cursor.Current=Cursors.Default set the Me.Current property to something (default)...
18
by: Eric Ridge | last post by:
Why must a cursor be defined in an open transaction? Obviously there's a good reason, but I can't figure it out. On a high level, what would be involved in allowing a cursor to outlive the...
0
by: govus | last post by:
Hi everyone- I'm using the Microsoft JDBC driver for SQL Server 2000 and I'm trying to avoid using server cursors. Is there a way to guarantee that every query will not create a server-side...
2
by: bevis | last post by:
I'm new to sql server and mysql but this seems like it should be a pretty straight forward jdbc connection. But I have spent almost 2 days just trying to get a jdbc connection. Please help if you...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.