Problem with ResultSet retrieved with SELECT * FROM pg_indexes WHERE tablename

From: Stefan Zweig <stefanzweig1881(at)web(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem with ResultSet retrieved with SELECT * FROM pg_indexes WHERE tablename
Date: 2007-07-23 15:42:36
Message-ID: 153540364@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2007-07-23 15:55:32 Re: Problem with ResultSet retrieved with SELECT * FROM pg_indexes WHERE tablename
Previous Message Mikko Tiihonen 2007-07-23 07:38:25 Fix database metadata tuple copying to work with binary data