Oracle ODP. NET database access connection string
Connection string attribute |
Default Value |
Description |
Connection lifetime |
0 |
Maximum life time (in seconds) of the connection when the database connection is returned to the connection pool, its creation time will be compared with the current time. If the time exceeds the time specified by the connection lifetime, it will be released. If the value is 0, it is considered as the maximum connection time. |
Connection timeout |
15 |
Maximum time (in seconds) to wait for a free connection from the pool |
Data Source |
Empty string |
Oracle Net service name that identifies the database to connect |
DBA privilege |
Empty string |
Administrative privileges: sysdba or sysoper |
Decr pool size |
1 |
Controls the number of connections that are closed when an excessive amount of established connections are unused |
Enlist |
True |
Enables or disables Serviced components to automatically enlist in distributed transactions when this value is true, all existing database connections in the pool will be added to the transaction context of its creation thread. If the transaction context does not exist, no changes are made. |
Incr pool size |
5 |
Controls the number of connections that are established when all the connections in the pool are used |
Max pool size |
100 |
Maximum number of connections in a pool |
Min pool size |
1 |
Minimum number of connections in a pool |
Password |
Empty string |
Password for the user specified by user ID |
Persist Security info |
False |
Enables or disables the retrieval of password in the connection string |
Pooling |
True |
Enables or disables Connection Pooling |
Proxy user ID |
Empty string |
User Name of the proxy user |
Proxy Password |
Empty string |
Password of the proxy user |
User ID |
Empty string |
Oracle user name |