Re: JDBCR4 How long will a database connection stay open

On 9 November 2016 at 02:34, Don Brown <DBrown@xxxxxxxxxx> wrote:

I am using the JDBCR4 service program to access a MSSQL database.

-snip-

If I do not close the connection (Eg jdbc_Close(conn); ) will the
connection stay open indefinitely ?

I am guessing so but I can't find any thing that confirms that.

If you don't close the connexion, it will stay open forever on your end.
Which is fine for your side of the glass; how about the far end?

Most database servers have a 'timeout', where they will disconnect and
reclaim inactive connexions. The key word here is 'inactive'. As long
as you are fetching rows, the connexion is active, and the inactivity
timer won't fire.

Having said that, if the program design is to fetch one row, perform
some long process (like put it on a 5250 display where the user goes
home for the weekend without signing off), you'll have an inactive
connexion after a while. That timeout depends upon the specific
database server you are connecting to - check with their admin.

Also consider network infrastructure connecting the two machines; it's
possible that a switch or router will reclaim a stale, unused
connexion - the network people can tell you that.

--buck