how to catch error from sql adapter

Why is it I already catch soapexception but still dont get any exception, but Biztalk is logging it in event viewer?

any idea or sample, to handle exception thrown by sql adapter.

Cheers,

Alex Tantiangco