Oracle ODP.NET数据库访问连接字符串
Connection String Attribute | 默认值 | 描述 |
Connection Lifetime | 0 | Maximum life time (in seconds) of the connection 当数据库连接被返回到连接池中时,它的创建时间将与当前时间比较,如果超过了 Connection Lifetime 规定的时间,它将被释放掉。为 0 时将被视为最大连接时间。 |
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 to |
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 当此值为 true 时,池中现存的所有数据库连接将被加入到它的创建线程的 Transaction Context 中。如果不存在这个 Transaction Context 则无任何变化。 |
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 |