Clifton Zama wrote:
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 [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Reply via email to