Re: jdbc and refcursor problem - Mailing list pgsql-interfaces

From Dave Cramer
Subject Re: jdbc and refcursor problem
Date
Msg-id 41B3B5C3.10403@fastcrypt.com
Whole thread Raw
In response to jdbc and refcursor problem  ("Gaetano Sferra" <gaesferr@libero.it>)
Responses Re: PL/JAVA  (Jaime Casanova <systemguards@yahoo.com>)
List pgsql-interfaces
Gaetano,

Try posting this to the jdbc list

pgsql-jdbc@postgresql.org


Dave

Gaetano Sferra wrote:

>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
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>  
>

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561



pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] PL/Python: How do I use result methods?
Next
From: Michael Fuhr
Date:
Subject: Re: [HACKERS] PL/Python: How do I use result methods?