Re: Connection closing

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