How can i continue executing other SQL Statments , even if one of them fails

[Ravi Kiran Va]

I am executing , some sql statements , now the requirement is such that , even if a single statement execution fails ,i want to continue executng the others .

But right now the condition is such that , even if a single SQL Statement fails the execution is currently stopped at that Line .

Please let me know how can i continue executing the others even one statement fails .

Thanks

[Rene Larsen]

We need to see your code.

The SQL won't stop - so it is in your JDBC code the change need to be made.

[Ravi Kiran Va]

Thanks for the response :

// Assume that the Table Users doesn't exists in the firsyt select query , so it will throw an Exception SQLException , i am handling that in my code, please tell me how can i make execute the next sequence of statements also

ResultSet rs = stmt.executeQuery("select NAME , PASS from Users");
while(rs.next())
{
// Do Some Operation 
}


ResultSet rs1 = stmt.executeQuery("select NAME , PASS from SMart");
while(rs1.next())
{
// Do Some Operation 
}

Any ideas

[Rene Larsen]

You need to take control over the Exceptions thrown from the stmt.executeQuery(..) by wrapping them into try/catch blocks.

try {
   ResultSet rs = stmt.executeQuery("select NAME , PASS from Users");
   while(rs.next()) {
   }
} catch (SQLException e) {
   /* do something e.g. save the Exception to be used later on, or just log it */
}

try {
   ResultSet rs1 = stmt.executeQuery("select NAME , PASS from SMart");
   while(rs1.next()) {
   }
} catch (SQLException e) {
   /* do something e.g. save the Exception to be used later on, or just log it */
}

[Ravi Kiran Va]

Thank you , what i am doing is that , for all the SQL Statements i am only using one Catch Exception block of SQLException , so in this case if one is failing the rest aren't being executed.

Anyway thanks for the help .