Problem with ResultSet retrieved with SELECT * FROM pg_indexes WHERE tablename

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