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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2005-06-13 13:30:12 | Re: in(...) clause and PreparedStatement |
Previous Message | Sergey Pariev | 2005-06-13 13:08:55 | in(...) clause and PreparedStatement |