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

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.