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..?
