FoxDataObjects - Object-Relational Mapping Tool for Visual FoxPro

ConnectionLifeTime Property
FoxDataObjects	Object-Relational Mapping Tool for Visual FoxPro®

Specifies how many seconds a connection to the database must be kept open when there is no database activity.

Session.ConnectionLifeTime [=nValue]

Property Values

Numeric

Remarks

The Session object could be set to maintain a permanent connection to the dataserver for the live time of the session or it can be set to automatically close the connection on inactive periods (for a given idle time out) and automatically reconnect when needed (this is useful when FDO is being used in conjunction with COM+ services or other middleware products with managed database connections pool).

When this property is set to 0, the database connection is kept open all the life time of the session object, regardless of the database activity (or inactivity).

When this property is set to a number greater than zero (0), the database connection is automatically closed after the indicated number of seconds expires since last transaction ending. A value greater than zero should be used in combination with Session.ConnectionMode=1 (CONNECTIONMODE_AUTOMATIC) for automatic connection/reconnection management.

See Also

Server.NewSession method | Session.Connect method | Session.ConnectionMode property | Session.Disconnect method

Applies to: Session object

Send feedback on this topic to RunAhead Technologies

For Technical support and product issues please contact us at support@foxdataobjects.com or visit http://www.foxdataobjects.com