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
|