A question on timeouts
0 posts in topic
Flat View  Flat View

Posted By:   vignesh_bala
Posted On:   Monday, September 18, 2006 07:31 AM

Hi all,
I have a small doubt. I have to do an insert which will inturn invoke a trigger. I had given 10 seconds of timeout using setQueryTimeout() of the statement object.But the insert takes nearly a minute( Including Trigger ).But I doesn't get any timeout exceptions. Is this because that the time taken fot the execution of trigger will not be taken as the time taken for given for the insert statement(that is the insert takes less than 10 s and trigger takes more time). Or is there any method other than using setQueryTimeout()? please clarify me.I need it urgently
Thanks & Regards,

About | Sitemap | Contact