try catch finally sequence

[Shankar Narayana]

Hi all,

I am very well aware of the situation in which the try, catch and finally work but i have a program code for which i am not able to determine what the sequence is..

Here goes the code:

 
public void addRecords(int reqType) throws Exception
{
    try
    {
       switch(reqType)
       {
             case 1 :
                  try
                  {
                      //do some database related stuff
                  }
                  finally
                  {
                        //close connection
                  }
                  break;
       }
    }
    catch(SQLException sqlEx)
    {
         //throw sqlEx
    }
    catch(Exception ex)
    {
            //throw ex
    }
}

Now my question is what happens if there is a Sql error in the case 1, will the finally be executed and then the error is caught or only the error is caught without finally.

[Ernest Friedman-Hill]

The "finally" is executed before the catch blocks are entered.

[Shankar Narayana]

so what happens to the exception, is it caught or left.

[Ernest Friedman-Hill]

It goes "through" the finally block and is caught.

[Ulas Ergin]

if an exception occurs in the try block of case 1
*first finally block of the try in case 1 will be executed
*exception will be handled by the catch block of the outer try since you have no catch block in the case 1's try