Hi
What would cause a connection to automatically close within a java program.It gets to a point where I have an inner loop that calls a recursive method that creates resultsets.But I am closing all my result sets, so I do not know why the connection simply closes itself.Please help.
Turn logging on at the server (or turn the level of detail up). There will be a line saying why the connection closed. Presumably there is a status code available via JDBC too, but the server-side logs will tell you whether PG or your client is closing the connection.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly