From: Gaetano Sferra <gaesferr@libero.it>
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: jdbc and refcursor problem
Date: Fri, 3 Dec 2004 15:20:15 +0100
Message-ID: <I85H5R$B4CD2326C7906242A84B9060C3AF1DBB@libero.it> (raw)
Hello to all,
I need to process a cursor returned by a stored function,
reading the jdbc driver docs I learned how to do it but I got a strange behavior
using metadata.
For xample:
CallableStatement cstm = conn.prepareCall("{ ? = call myfunction() }");
cstm.registerOutParameter(1, Types.OTHER);
cstm.execute();
ResultSet rs = (ResultSet) cstm.getObject(1);
ResutlSetMetaData rsmd = rs.getMetaData();
int columns = rsmd.getColumnCount() // <-- this throw a NullPointerException
I got a NullPointerException when try to retrieve the ResultSet column count
even if the ResultSet contains or not data. Is there a workaround?
Thanks,
Gaetano Sferra
____________________________________________________________
Libero ADSL: 3 mesi gratis e navighi a 1.2 Mega, senza costi di attivazione.
Abbonati subito su http://www.libero.it
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-interfaces@postgresql.org
Cc: gaesferr@libero.it
Subject: Re: jdbc and refcursor problem
In-Reply-To: <I85H5R$B4CD2326C7906242A84B9060C3AF1DBB@libero.it>
* 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