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