Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group