RE: JDBCR4 How long will a database connection stay open

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