adapter.fill method Catch and Finally block do not execute
-
I have the below lines of code in a windows service. When I run the service locally this works fine. But on the server it creates an issue on line no 6 "_dAdapter.Fill method". I can not debug it on the server as there is no VS 2005 installed. The issue is the program just hangs and do not move further to line no 6 and it never comes on catch. It do not come on Finally block too. Please advice. 1. try 2. { 3. ... 4.OracleDataAdapter _dAdapter = new OracleDataAdapter(); 5. _dAdapter.SelectCommand = _oCom; 6. _dAdapter.Fill(dsGetOrder, "process"); 7. } 8. catch (Exception ex) 9. { 10. ... 11. } 12. finally { }
Regards, Pavas
-
I have the below lines of code in a windows service. When I run the service locally this works fine. But on the server it creates an issue on line no 6 "_dAdapter.Fill method". I can not debug it on the server as there is no VS 2005 installed. The issue is the program just hangs and do not move further to line no 6 and it never comes on catch. It do not come on Finally block too. Please advice. 1. try 2. { 3. ... 4.OracleDataAdapter _dAdapter = new OracleDataAdapter(); 5. _dAdapter.SelectCommand = _oCom; 6. _dAdapter.Fill(dsGetOrder, "process"); 7. } 8. catch (Exception ex) 9. { 10. ... 11. } 12. finally { }
Regards, Pavas
mpavas wrote:
I can not debug it on the server as there is no VS 2005 installed.
But you can add instrumentation and logging to get a view of what is happening inside your application.
mpavas wrote:
The issue is the program just hangs and do not move further to line no 6 and it never comes on catch. It do not come on Finally block too
Is your live database bigger than your test/development database? The issue could be that it is attempting to load in all that data into memory.
* Developer Day Scotland 2 - Free community conference * The Blog of Colin Angus Mackay
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
-
I have the below lines of code in a windows service. When I run the service locally this works fine. But on the server it creates an issue on line no 6 "_dAdapter.Fill method". I can not debug it on the server as there is no VS 2005 installed. The issue is the program just hangs and do not move further to line no 6 and it never comes on catch. It do not come on Finally block too. Please advice. 1. try 2. { 3. ... 4.OracleDataAdapter _dAdapter = new OracleDataAdapter(); 5. _dAdapter.SelectCommand = _oCom; 6. _dAdapter.Fill(dsGetOrder, "process"); 7. } 8. catch (Exception ex) 9. { 10. ... 11. } 12. finally { }
Regards, Pavas
Hangs for how long ? Sounds like it's just taking a long time to execute the call.
Christian Graus Driven to the arms of OSX by Vista.