Abnormal network status of the Database Connection Pool

When the database connection is normal, the connection can be effectively handled in the normal network status.
However, when a network exception occurs, the connection pool cannot rejudge the previously valid connections.The connection is successful by default, resulting in exceptions.
In addition, if transaction is usedAs a result, the connection is still unavailable, and transaction will always think that the connection is not available.To the database.
In this case, the line can be determined when a transaciton exception occurs.The connection in the process pool is deleted incorrectly and reconnected. This will solve the problem.
Sqlconnection and oracleconnec in. NET Framework 2.0Tion includes the clearpool method, which is used to clear the specified connection.