Skip site navigation (1) Skip section navigation (2)

Re: Getting Reference cursors

From: Andrés Luna <aluna(at)ifxcorp(dot)com>
To: "'Kris Jurka'" <books(at)ejurka(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Getting Reference cursors
Date: 2005-06-13 13:13:52
Message-ID: 000801c57019$bf1588c0$ab78100a@ifx.local (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
 


In response to

Responses

pgsql-jdbc by date

Next:From: Csaba NagyDate: 2005-06-13 13:30:12
Subject: Re: in(...) clause and PreparedStatement
Previous:From: Sergey ParievDate: 2005-06-13 13:08:55
Subject: in(...) clause and PreparedStatement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group