Announcement Announcement Module
No announcement yet.
timeout not workign Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • timeout not workign

    from my application i am executing StoredProcedure , my class is extending StoredProcedure class provided by SPring API,
    i use setQueryTimeOut(1), but after 1 sec it is not throwing any timeout Exception,
    then i configured JTATransactionManger , but still there is no timeout after 1 sec.

    can you please assist me how can i confiure queryTimeout with 1 sec.

    i have sqlServer2005 as DB with driver

    this is how i confiure transactionManager
    <bean id="txManager"
    class="org.springframework.transaction.jta.JtaTran sactionManager">

    <property name="defaultTimeout">

    <tx:advice id="txAdvice" transaction-manager="txManager">
    <!-- the transactional semantics... -->

    <tx:method name="*" />

    <aop:config proxy-target-class="true">
    <aopointcut id="timeoutOperation"
    expression="execution(* my.proc.sp.ExtractStoredProc.*(..))" />
    <aop:advisor advice-ref="txAdvice"
    pointcut-ref="timeoutOperation" />

    please assist me if any otherthing i need to do, or there is some other way to acchive this.