Re: NullPointerException in ResultSetMetaData getColumnCount

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tomas <tomas(dot)johansson(at)agent25(dot)se>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: NullPointerException in ResultSetMetaData getColumnCount
Date: 2004-10-18 20:21:49
Message-ID: Pine.BSO.4.56.0410181515590.5115@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Mon, 18 Oct 2004, Tomas wrote:

> How can you get metadata from a resultset that is returned from a
> stored function ?

You need to be running with autocommit off for this to work at all. This
is not just a metadata problem. The problem is that cursors are closed at
commit, which in auto commit mode is before the results can even be
fetched from it. It could definitely use a better error message, the 8.0
driver gives "ERROR: cursor "<unnamed portal 1>" does not exist", but
that's still not very good.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bacchu, Anjan 2004-10-19 00:06:27 FW: your post to pgjdbc-commit
Previous Message Kris Jurka 2004-10-18 19:18:19 Re: boolean problem