Keep Oracle Connection
Posted: Wed 07 Jan 2009 16:27
Hi,
We found another issue and we are not sure if it has something to do with Unidirect component or our version of the Oracle database. We are using Oracle Express and Unidirect Pro. All connections to the database are from webservices Asp.Net. When we call database and execute any command successfully, connection to the DB closes without problem, but if the program catches exception during the execution of the command then, disregard all "Finally" blocks and "Using" blocks, connection is still alive in the Oracle database (visible in Oracle Manager), but Unidirect Connection component shows that connection is closed. Do you have any idea, why that can happens?
Thank you,
Galina
We found another issue and we are not sure if it has something to do with Unidirect component or our version of the Oracle database. We are using Oracle Express and Unidirect Pro. All connections to the database are from webservices Asp.Net. When we call database and execute any command successfully, connection to the DB closes without problem, but if the program catches exception during the execution of the command then, disregard all "Finally" blocks and "Using" blocks, connection is still alive in the Oracle database (visible in Oracle Manager), but Unidirect Connection component shows that connection is closed. Do you have any idea, why that can happens?
Thank you,
Galina