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

  • timeout not workign

    hi
    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 com.microsoft.sqlserver.jdbc.SQLServerDriver.

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

    <property name="defaultTimeout">
    <value>1</value>
    </property>
    </bean>

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

    <tx:method name="*" />
    </tx:attributes>
    </tx:advice>

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

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