ODAC (V9.5.15) study notes (iii) torasession (1)

1. Connection related

Name	Type	Description
Connectdialog		To execute a Connection dialog box control
Connected	Boolean	Connection status, connecting to or shutting down the database connection via function Connect and disconnect, and triggering the Onconnectchange event.
ConnectMode	Tconnectmode	Database connection method, the value is as follows: Cmnormal default, normal user connection Cmsysasm Connect as Sysasm role CMSYSDBA Connect as SYSDBA role Cmsysoper Connect as Sysoper role
Connectprompt	Boolean	Whether a password is forced when a database connection is entered
ConnectString	String	The connection string, using an ODBC-like connection string, can also be automatically generated by setting properties such as username, password, and so on.
Username Password Server	String	The user name and password of the database login, already the service name. When you use direct mode, the format of the server is: IP:Port:SID such as: 127.0.0.1:1521:ORCL
Disconnectedmode	Boolean	If set to True, database connections are only made when needed, and when an action is completed, the database connection is automatically closed to conserve the resources of the database server. Typically used in client-side data offline mode.
Pooling	Boolean	Whether to start the connection pooling feature, if the connection pooling feature is started, when the connection is closed, it is actually placed in the pool, the connection will be checked for its connection state before returning to the pool, and if it is disconnected, it will not be put in the pool, but is automatically freed. The connection pool checks every 30 seconds if the connection in the pool is really connected, and if the connection in the pool is broken, it is freed and removed. Note Once you use connection pooling, you should focus on the maximum number of buffers and setting too small will cause the connection pool to error.
Poolingoptions	Tpoolingoptions	Connection pooling options, where
	Connectionlifetime	The time-to-live (in milliseconds) of a connection in the connection pool, which is freed and removed by the connection pool if it is not used, and the default is 0, which indicates an infinite length
	Maxpoolsize	Pool buffer maximum number, default 100, in the actual application of small, can be appropriately increased
	Minpoolsize	Pool Buffer Minimum number
	Validate	When you get a connection from a pool, this parameter determines whether to check its connection status. If true indicates to be checked that if the connection obtained from the pool is found to be fractured, the connection is freed, that is, the connection secured from the connection pool must be connected.
	Pooltype	Connection pool type Torapoolingtype, its value and meaning are as follows: Optlocal maintained by ODAC, default Optmts Maintained by MTS Optoci maintained by OCI
Removefrompool		Forces the current connection to be closed, no longer entering the connection pool, but removing from the connection pool
Threadsafety	Boolean	OCI thread-Safe in multi-threading, default True
Onfailover	Tfailoverevent	In failover mode, the event is triggered when a database reconnect occurs.

ODAC (V9.5.15) study notes (iii) torasession (1)