×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I would presume that opening a connection to a database would be a fairly
heavy (for sake of a better word) operation and if I am going to open and
close a connection to the database say a thousand times in a batch process
this would not be very efficient. I would also expect the operation to
check if the connection is still open is also a heavy operation.
I am guessing there would be some way to look at a MSSQL server and see
how many current open connections there are. Don't know how ?
The MSSQL server is a business critical application and I need to be as
efficient as possible when accessing this database.
Is the load on a MSSQL database of opening a connection similar to that of
a ILE program opening a DB2 database file or is there a comparison as to
what opening a connection actually includes ?
What I think I am going to do is save a time stamp when I open the
connection and check the elapsed time on each call and if x number of
seconds have elapsed I will check if the connection is still open.
Cheers
Don Brown
From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 11/11/2016 12:13 AM
Subject: RE: JDBCR4 How long will a database connection stay open
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
Best to check to make sure the connection is still open.
-----Original Message-----
From: Don Brown [mailto:DBrown@xxxxxxxxxx]
Sent: Wednesday, November 09, 2016 1:35 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: JDBCR4 How long will a database connection stay open
Hello,
I am using the JDBCR4 service program to access a MSSQL database.
I have a service program that is used to retrieve a single record from the
database which is called from interactive programs where the user needs to
retrieve additional information which is working great.
I now have a requirement to check the values for a number of records in a
batch process. So the number of individual records retrieved could be in
the thousands.
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.
Thank you for any assistance
Don Brown
As an Amazon Associate we earn from qualifying purchases.
This thread ...
Re: JDBCR4 How long will a database connection stay open, (continued)
This mailing list archive is Copyright 1997-2025 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.