On 9 November 2016 at 02:34, Don Brown <DBrown@xxxxxxxxxx> wrote:
I am using the JDBCR4 service program to access a MSSQL database.
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.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].