|
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 |
// C#
...
OracleConnection con = new OracleConnection();
con.ConnectionString = "User Id=scott;Password=tiger;Data Source=oracle;Pooling=true;Enlist=true;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5; Decr Pool Size=2";
con.Open();
...
以下网站提供连接字符串大全：
