From: Vsevolod (Simon) Ilyushchenko <simonf@cshl.edu>
To: pgsql-sql@postgresql.org
Subject: cursor "<unnamed portal 1>" does not exist
Date: Wed, 15 Jun 2005 18:45:56 -0400
Message-ID: <42B0AFA4.202@cshl.edu> (raw)
Hi,
I'm querying a Postgres 8.0.3 database from Java via the 8.0-311 JDBC
driver. It mostly works. I ran into the "cursor does not exist" problem,
but was able to fix it with
connection.setAutoCommit(false);
Or so I thought.
There are several JSP pages which still throw the 'cursor "<unnamed
portal 1>" does not exist' error. Everything works well if I call the
same Java fuction on the command line.
I tried to observe the network packets and found an interesting thing:
the "select *" queries and responses that works look like this:
Request S_1 BEGIN select * from user_pkg.GetPerson_fcn($1) as result 571
Response BEGIN result <unnamed portal 1>C SELECT
While those that fail look like this:
Request select * from material_pkg.ListCautions_fcn($1,$2) as result B
Response result <unnamed portal 1>C SELECT
Note that the successful ones contain strings "S_1" and "BEGIN", and the
failed ones do not. However, there also are successful queries without
these strings, but they are not "select *" queries. Eg,
Request SELECT typname FROM pg_catalog.pg_type WHERE oid=$1 1790
Response typname refcursorC SELECT
When I do it successfully on the command line, the "S_1" and "BEGIN"
lines are also present in the query.
I have a feeling it's some idiosyncrasy that I'm not familiar with. Does
"BEGIN" refer to the beginning of a trasaction?
I will be grateful for any suggestions.
Simon
--
Simon (Vsevolod ILyushchenko) simonf@cshl.edu
http://www.simonf.com
Terrorism is a tactic and so to declare war on terrorism
is equivalent to Roosevelt's declaring war on blitzkrieg.
Zbigniew Brzezinski, U.S. national security advisor, 1977-81
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: simonf@cshl.edu
Subject: Re: cursor "<unnamed portal 1>" does not exist
In-Reply-To: <42B0AFA4.202@cshl.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox