ich write a client(c# program) that connect to oracle db via oracle client and ado.net.
i open a connection at the start of my programm and close it at the end and exit of my program.
i want to reconnect when the connection lost. when the connection lost i close the connection and reopen it with open. my problem is that close and reopen d'ont cause a exception !!!!!!
can anyone explain me why???
i have deaktivite the pooling but the same probleme. i have remarked that the connection will be closed later by the second retry to reconnect.
By default an OracleConnection is actually a connection pool with 50 connections in it. It is global in scope automatically. Just because the Connection object goes out of scope does not mean it is disconnected. It just goes back into the pool.
You could try disabling pooling if you want (see connection string parameters for more info) but the pool is a very powerful feature that you may want to use.