1 Reply Latest reply on Mar 31, 2005 11:12 AM by Adrian Brock

    JBoss 3.2.1 with Sybase IQ 12.5

    Dr. Vodka Newbie

      Hi,
      After invoking a fairly large Stored Proc (execution time exceeding 20 mins) from withine JBoss, the control is never returned to the application from the sybase database.

      After examining the Sybase logs we found this log snippet stating that the caller had dropped the connection.0000007634 Insert Started.
      0000007634 yadavb.#SQLGENTEMP
      0000007634 Exception Thrown from /cm/iqa/include/dfo.h:1085, Err# 0, tid 151 origtid 151
      0000007634 O/S Err#: 0, ErrID: 519 (hos_attnexception)
      0000007634 The operation has been cancelled by the user
      0000007634 Exception Thrown from /cm/iqa/include/dfo.h:1085, Err# 0, tid 151 origtid 151
      0000007634 O/S Err#: 0, ErrID: 519 (hos_attnexception)
      0000007634 The operation has been cancelled by the user

      My sybase-DS looks like this:
      <local-tx-datasource>
      <jndi-name>jdbc/SybaseDB</jndi-name>
      <connection-url>jdbc:sybase:Tds:SUN47.**.**.COM:5050</connection-url>
      <driver-class>com.sybase.jdbc2.jdbc.SybDataSource</driver-class>
      <user-name>****</user-name>
      <min-pool-size>20</min-pool-size>
      <max-pool-size>40</max-pool-size>
      <idle-timeout-minutes>5</idle-timeout-minutes>
      <blocking-timeout-millis>10000</blocking-timeout-millis>
      </local-tx-datasource>

      Can you guys provide some pointers to this issue..?