RE: JDBCR4 How long will a database connection stay open

Thank you for the responses.

Justin -

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.


//----------------------------------------------------------------------

// --------------------------------------------------
// Procedure name: connectionIsClosed
// Purpose: Check if JDBC connection is closed
// Returns: Connection closed (T/F)
// Parameter: connection object
// --------------------------------------------------
Dcl-pr connectionIsClosed ind
ExtProc(*java :'java.sql.Connection' :'isClosed')
End-pr;





-----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