Re: Getting Reference cursors

Kris

Thanks for your quick answer. However, now I change to the 8.0 driver
and still doesn´t work. The same code now fails during stored procedure
execution. Here is the stack trace.

java.sql.SQLException: ERROR: cursor "<unnamed portal 1>" does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1471)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1256)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
175)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:389)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:314)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLQuery(AbstractJdbc2C
onnection.java:192)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.internalGetObject(AbstractJd
bc2ResultSet.java:165)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2Resul
tSet.java:2328)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:342)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:321)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(Po
oledConnectionImpl.java:467)
at $Proxy1.execute(Unknown Source)
...

Tks in advance!

-----Mensaje original-----
De: Kris Jurka [mailto:books(at)ejurka(dot)com]
Enviado el: domingo, 12 de junio de 2005 1:07
Para: Andrés Luna
CC: pgsql-jdbc(at)postgresql(dot)org
Asunto: Re: [JDBC] Getting Reference cursors

On Fri, 10 Jun 2005, [iso-8859-1] Andrés Luna wrote:

> Im using the JDBC driver to connect to a Postgres Database. I have a
> function that returns a reference cursor and it works ok returning
> result itself. However, whenever I try to use the result set meta data

> of the ref cursor it doesn't work. Let me explain better:

This is fixed in the 8.0 driver.

Kris Jurka

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 11/06/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.6.9 - Release Date: 11/06/2005