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

[Dave Cramer <pg(at)fastcrypt(dot)com>]

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