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 |