OracleConnection Properties
OracleConnection properties are listed in Table 6-48
Table 6-48 OracleConnection Properties
| Property | Description |
|---|---|
|
Used to get or set |
|
|
Specifies the action name for the connection |
|
|
Indicates whether to allow the user to select a specific TLS/SSL certificate via a graphical interface for their database connection when using a MCS wallet location Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies whether to commit each SQL statement implicitly or only until an explicit commit occurs |
|
|
Enables using a HTTPS proxy server for the ODP.NET connection |
|
|
Specifies the binding method in the collection Not Available in ODP.NET, Unmanaged Driver |
|
|
This setting pauses the connection request until the migration completes or fails to migrate in the specified time, then connect to the correct shard with the data requested. Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the client identifier for the connection |
|
|
Specifies the client information for the connection |
|
|
Specifies the number of seconds the command is allowed to execute before terminating the execution with an exception Not Available in ODP.NET, Unmanaged Driver |
|
|
Identifies a particular application's connections by appending its string to the connection identifier Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies connection information or URL used to connect to an Oracle database |
|
|
Indicates the maximum amount of time that the |
|
|
Determines whether a particular connection object is associated with a TimesTen database connection, an Oracle database connection, or no physical connection Not Available in ODP.NET, Managed Driver and ODP.NET Core |
|
|
|
Inherited from |
|
Used to get or set an |
|
|
Not Supported |
|
|
Specifies the name of the database domain to which the connection is set |
|
|
Sets or gets the edition name for the |
|
|
Specifies the name of the database to which the connection is set |
|
|
Specifies the Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect |
|
|
Specifies a logical name that identifies the DRCP connection pool that the ODP.NET connection will use |
|
|
Specifies whether an application can reuse a pooled session ( |
|
|
Specifies the total memory size, in bytes, that the provider allocates to cache data fetched in one database round-trip Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the name of the host to which the connection is set |
|
|
Specifies the HTTPS proxy server |
|
|
Specifies the HTTPS proxy server port number |
|
|
Specifies the name of the instance to which the connection is set |
|
|
Specifies if the current application is in a transaction |
|
|
Specifies the isolation level of the local transaction |
|
|
Specifies whether to keep an idle connection alive. Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the time interval after an unacknowledged probe before a new probe is sent. Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the idle time before a keepalive probe is sent. Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the maximum number of statements that can be cached when self-tuning is enabled Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the module name for the connection |
|
|
Gets or sets the Oracle Cloud Identifier (OCID) of the target database's compartment |
|
|
Gets or sets the target database's Oracle Cloud Identifier (OCID) |
|
|
Gets or sets the URL end point for getting the database token |
|
|
Gets or sets the Oracle Cloud Identifier (OCID) of the IAM user’s cloud tenancy to retrieve the database token |
|
|
Sets the connection |
|
|
Used to set and get the name of the pluggable database to which the session is connected to |
|
|
Enables asynchronous execution on the database server side Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the ODP.NET provider type and version Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the ODP.NET NuGet version number Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the ODP.NET assembly version |
|
|
Specifies whether local configuration file access, such as to wallet and |
|
|
Specifies the session data unit size (SDU) for Oracle networking communication between client and server |
|
|
Specifies the version number of the Oracle database to which the |
|
|
Specifies the name of the service to which the connection is set |
|
|
Specifies the time to wait before retrying connecting to a service that becomes unavailable Not Available in ODP.NET, Unmanaged Driver |
|
|
|
Inherited from |
|
Specifies the minimum authentication protocol that is to be used for a given |
|
|
This property enables one or more authentication services, such as TCP/IP with SSL. |
|
|
Specifies the TLS/SSL certificate thumbprint in the certificate store for the ODP.NET connection to use |
|
|
Sets the distinguished name (DN) string that will be used to validate the server certificate DN |
|
|
Enables server certificate distinguished name (DN) validation |
|
|
Sets which SSL/TLS version to use for the connection |
|
|
Specifies the current state of the connection |
|
|
Specifies the current size of the statement cache associated with this connection |
|
|
Specifies whether to suppress the Not available in ODP.NET, Unmanaged Driver |
|
|
If the returned pooled connection changed its service name ( |
|
|
Configures Transparent Application Failover behavior on the connection Not available in ODP.NET, Unmanaged Driver |
|
|
Specifies the directory location of Not Available in ODP.NET, Unmanaged Driver |
|
|
Sets the value for Not Available in ODP.NET, Unmanaged Driver |
|
|
Gets or sets the token location path for the connection where the signature token and private key files are located Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies whether to use Client Initiated Continuous Query Notification (CICQN) or traditional Continuous Query Notification (CQN) that does not rely on a persistent connection Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies whether the hour offset can be used for the session time zone, when the Oracle time zone region name that is associated with the .NET locale is not supported by the Oracle database being used Not Available in ODP.NET, Unmanaged Driver |
|
|
Specifies the location of wallets. Wallets are certificates, keys, and trustpoints processed by SSL/TLS Not Available in ODP.NET, Unmanaged Driver |