Thread: Problem with ResultSet retrieved with SELECT * FROM pg_indexes WHERE tablename

Problem with ResultSet retrieved with SELECT * FROM pg_indexes WHERE tablename

From

Stefan Zweig

Date:

23 July 2007, 12:46:43

hi list,

i hope anybody can help me with this thing:

i tried to select all indexes of a table with the following statement via jdbc:

Statement pgstatement;
Connection pgconnection;
...
pgstatement = pgconnection.createStatement();

query= "SELECT * FROM pg_indexes WHERE tablename ='g_g114'";
pgresultSet=pgstatement.executeQuery(query);


after that i want to step through the ResultSet with
while(pgresultSet.next())
{...}

but i get an exception from pgresultSet.next() which says:

org.postgresql.util.PSQLException: DataSource has been closed


what can be the mistake?

i appreciate any help,

thanks, stefan
_____________________________________________________________________
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066

Re: Problem with ResultSet retrieved with SELECT * FROM pg_indexes WHERE tablename

From

Dave Cramer

Date:

23 July 2007, 12:55:40

On 23-Jul-07, at 11:42 AM, Stefan Zweig wrote:

> hi list,
>
> i hope anybody can help me with this thing:
>
> i tried to select all indexes of a table with the following
> statement via jdbc:
>
> Statement pgstatement;
> Connection pgconnection;
> ...
> pgstatement = pgconnection.createStatement();
>
> query= "SELECT * FROM pg_indexes WHERE tablename ='g_g114'";
> pgresultSet=pgstatement.executeQuery(query);
>
>
> after that i want to step through the ResultSet with
> while(pgresultSet.next())
> {...}
>
> but i get an exception from pgresultSet.next() which says:
>
> org.postgresql.util.PSQLException: DataSource has been closed
>
There should be no problem with the query, although you can get the
indexes from the metadata. Can you try any other query to see if it
fails ?

Dave
>
> what can be the mistake?
>
> i appreciate any help,
>
> thanks, stefan
> _____________________________________________________________________
> Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
> http://smartsurfer.web.de/?mc=100071&distributionid=000000000066
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq