Announcement Announcement Module
Collapse
No announcement yet.
how to raise excepotion on calling stored procedure when timeout Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • how to raise excepotion on calling stored procedure when timeout

    Hi Everyone,

    I am using "spring 2.5" in my applicaton.

    Up to know i havent had any problem with calling a stored procedure. Bu now i need something different like that;

    When i call a stored procedure, i want to set a timeout value (5 seconds).

    When the application calls the stored procedure, if elapsed time greater then 5 secons then i want my application raise an exception an rollback the transactions in the store procedure.

    I mean, the stored procedure must do the work in 5 seconds or the transaction must be rolled back .

    how can i handle that situation?

    (when i set "querytimeout" attribute of stored procedure object, the application raises exception when timeout but not rollback)

    thanks in advance
    Last edited by louiseburg; Feb 16th, 2009, 10:24 AM.
Working...
X