R
Rizwan
I have some INSERT statements on a table "PAYROLL" which I execute them as
batch. I am catching the SQLException in this case.
Statement stmt = ...;
try {
stmt.executeBatch();
stmt.clearBatch();
} catch (SQLException sqle) {
System.out.println( "SQLException= " + sqle.getMessage() );
sqle.printStackTrace();
}
Now there is an INSERT trigger on this table which can update one or more
table. I find out that if the trigger failed then the SQLException is not
catching it. Why it is doing like that?
Thanks
batch. I am catching the SQLException in this case.
Statement stmt = ...;
try {
stmt.executeBatch();
stmt.clearBatch();
} catch (SQLException sqle) {
System.out.println( "SQLException= " + sqle.getMessage() );
sqle.printStackTrace();
}
Now there is an INSERT trigger on this table which can update one or more
table. I find out that if the trigger failed then the SQLException is not
catching it. Why it is doing like that?
Thanks